G
Guest
I have a Form Attendees which has a subform Calender, the calender was
originally a form on its own and i had to select the AttendeeID (primarykey
for Attendees) manually, i am new to access but have added the calender to
the attendees form to allow easy access to the attendance records how do i
get the subform to automatically select the correct AttendeeID for the record
shown in the main form.
i originally tried to do it with setting the record source to
SELECT [Attendees].[AttendeeID] FROM Attendees WHERE
((([Attendees].[AttendeeID])=[Forms]!Attendee!AttendeeID));
this just gives me a drop down list of all attendeesID's but does not select
the one in the main form.
originally a form on its own and i had to select the AttendeeID (primarykey
for Attendees) manually, i am new to access but have added the calender to
the attendees form to allow easy access to the attendance records how do i
get the subform to automatically select the correct AttendeeID for the record
shown in the main form.
i originally tried to do it with setting the record source to
SELECT [Attendees].[AttendeeID] FROM Attendees WHERE
((([Attendees].[AttendeeID])=[Forms]!Attendee!AttendeeID));
this just gives me a drop down list of all attendeesID's but does not select
the one in the main form.