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!!!

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

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