Subform Form select record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Phil - 01 Sep 2005 14:50 GMT

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.

Reply to this Message

Dennis - 01 Sep 2005 15:02 GMT

When you add a subform to a main form, the wizard should ask which fields
link the sub form to the main form so that the records automatically change
on the sub form as the main form record changes. In design view select the
sub form and then show the properties, fill in the master and child link
fields that link the forms.

> 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
[quoted text clipped - 10 lines]
> this just gives me a drop down list of all attendeesID's but does not select
> the one in the main form.

Reply to this Message

Phil - 01 Sep 2005 15:42 GMT

Thanks alot worked great, i was not given the choice by the wizard when i
first did it, but i was able to define master/child field manually.

thanks

Phil

> When you add a subform to a main form, the wizard should ask which fields
> link the sub form to the main form so that the records automatically change
[quoted text clipped - 16 lines]
> > this just gives me a drop down list of all attendeesID's but does not select
> > the one in the main form.

Reply to this Message