Associate
- Joined
- 23 Mar 2008
- Posts
- 275
Right it's basically an appointment system im doing at the moment...
The following line of code is from frm_appointment used to check if a certain appointment time is available on
frm_appointment_dummy is purely there to feed information.
Now this all works great... frm_appointment_dummy is being filtered and if a result comes up then there is obviously already an appointment for that date/time/staff member.
Now i want to put this into a subform and that's where it goes wrong... It seems it can't grab the values of staffid and dyddiad (welsh for date).
The new form is called staffsb with the subform being child0
How do i get the value of staff id? ive tried
Forms![frm_staffsb]![child0]![frm_appointment]![staffid]
With no success... Thoughts?
Many Thanks
The following line of code is from frm_appointment used to check if a certain appointment time is available on
Code:
DoCmd.OpenForm "frm_appointment_dummy", , , "[staffid]=Forms![frm_appointment]![staffid] and [timeslotid]=1 and [dyddiad]=forms![frm_appointment]![dyddiad]", , acHiddenfrm_appointment_dummy is purely there to feed information.
Now this all works great... frm_appointment_dummy is being filtered and if a result comes up then there is obviously already an appointment for that date/time/staff member.
Now i want to put this into a subform and that's where it goes wrong... It seems it can't grab the values of staffid and dyddiad (welsh for date).
The new form is called staffsb with the subform being child0
How do i get the value of staff id? ive tried
Forms![frm_staffsb]![child0]![frm_appointment]![staffid]
With no success... Thoughts?
Many Thanks
