Displaying data on a form and multiple sub-forms

[JRG0620]

I apologize if this subject has been answered in another forum. I am new to this web forum but not new to programming. I’ve programmed for 20+ years but rarely in MSAccess and VB. A little background: I have a main form (ProjectInq) with two sub-forms (BldgInq and CatInq). All fields are unbound because I want the user to initiate the necessary action. When the user enters the Project Number on the ProjectInq form and clicks ‘Find’, I want to retrieve the Project information from the Project Table and at the same time, retrieve the building information (1:N rows) from the Building Table (displayed on the BldgInq Sub-Form) and also the Category information (1:N rows) from the Category Table (displayed on the CatInq Sub-Form). All three tables have Project Number as one of the elements. I have queries developed that will use the Project Number on the ProjectInq main form as the parameter to the sub-form inquiries.

The issues I am having is that the sub forms are not executing when the user clicks ‘Find’. The sub-forms display the correct information when executed on their own but nothing displays as part of the main form. I’ve tried DoCmd.OpenForm but this opens the sub-forms as ‘pop-ups’. I want the data returned to the sub-forms within the main form. Any help or advise is greatly appreciated.

 

[ezfriend]

You probably have the answer by now, but just in case.

I am assuming that when user click on Find, the data for the sub form is modified/filtered.
I haven't test, but try this.

Form_frmSubForm1.Requery
Form_frmSubForm1.Refresh

 

[JRG0620]

EZFRIEND, Thanks for the advise. I'm obviously doing something wrong in the statement. I am now getting the MicroSoft error message "Object Required"