Set RecordSource of subform

[eacollie]

I have a main form with event information and a subform with contact information. Events can be from one of two facilities and the contacts for each facility are kept in separate databases.

I'd like to be able to set the recordsource of the subform (with contact information) depending on the facility.

Is this possible?

 

[pbaldy]

This help?

http://access.mvps.org/access/forms/frm0031.htm

 

[eacollie]

Thanks Paul.
If I set the recordsource of the subform at the OnCurrent event of the main form, can I have a combobox on the subform and select contacts from it? I don't want to edit the contact information, just select it so that it displays in the subform?

 

[pbaldy]

I don't see why not, but I don't completely understand what you're trying to do.

 

[eacollie]

Thanks Paul.

I hope I can explain clearly.

I have a table of EVENTS and I have two tables for CONTACTS (each is linked from another database).

An EVENT can occur in one of two facilities. Each EVENT has a CONTACT person. This CONTACT person can come from one of the two linked tables (depending on the facility).

I'm trying to create a subform on the EVENT form to display the CONTACT person for that EVENT.

If I change the recordsource for the subform depending on the facility in the OnCurrent event of the form, how do you link the subform to the main form if the subform is not bound?

 

[eacollie]

I've been able to set the LinkChildFields/LinkMasterFields in the OnCurrent event of the main form and it seems to work.

How/where do I set the properties for the combo box on the subform?