Subform should be "empty" until all choices are done.

[schwabe]

Hi all,

I have three comboboxes in the mainform:
- cboOEM
- cboODM


give the OEM and ODM customer and
- cboProject
gives the Projectname.

Then, I have a subform which gives a history of the customer orders.

The two forms a linked by:
Link Master Fields cboProjectID;cboOEMID;cboODMID
Link Child Fields lnkProject;lnkOEM;lnkODM

When I have, e.g. only an OEM customer chosen, the subform represents the whole history for this OEM and therefore mixes several projects.

I'd like to have an empty subform as long as no single project is chosen. Once the single [project is chosen, the subform should show the corresponding data.

Any idea how I do something like that?

Thanks,
Benjamin

[schwabe]

Hi all,

this is how I resolved the problem, but there might be more ideas out there:

I've added to the After Update for the ProjectID combo box this code:

Me.sfrmBoM.Visible = True
Me.sfrmOrders.Visible = True

and for form load and the reset button the following code:

Me.sfrmOrders.Visible = False

It does the job.