Subform link to combo box

[Steven811]

Hi - Novice here

I've searched the forums and can't see/understand a solution to my problem.

I have an unbound parent form with 2 cascading combo boxes. I have a subform sourced through a query and I wish to link this to a combo box in the parent so that I only show the related records. I have added a column to the combo (hidden) with the primary key, the subform query holds the foreign key.

My inexperience told me it was simple, hence my request for some help.

I thought that I had to link the forms through the subform properties of link child/master fields but I get an error message "can't build a link between unbound forms".

Any help would be appreciated.

Steven811

 

[PHV]

You may play with the Filter and FilterOn properties of the subform in the AfterUpdate event procedure of the combo.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Steven811]

Thanks for having a look.

I want the subform to reflect the combo box selection.

I've had a look at the filter options but I'm unsure how they would help as I need to link the 2 forms and then show the data associated with the combo box selection.

 

[PHV]

filter options but I'm unsure how they would help
By setting it in the AfterUpdate event procedure of the combo ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Steven811]

I'm sorry to appear so stupid. I don't understand how that will help if I can't link the form.