Have 1form/2subforms want to ask user for specific parameter at switchboard??

[SBergfeldJohnson]

I have a form which contains 2 sub forms, I don't want all the records to appear for the user to input information, I want the user to be asked for the collection id in the switchboard and then only that record would appear? I have tried several things but nothing seems to work. The initial form is not for input but to ensure the user is putting the right information on the right account. I tried putting a parameter on a query and making the initial form based on the query but it makes the 2 subforms disappear? I am lost and frustrated, any help would be great!!!

 

[Anauz]

you may need to requery the subforms, do this in the load event of the form.

 

[llkhoutx]

Your two subforms must be linked to the mainform. check the Master/Child properties of your subforms.