Subform right click

[abbers_01]

I have a subform with a list box that references a control on its parent form. The rowsource works fine except that the list won't query until I right click the sub form, at which point a menu comes up that like the following:
-------------------
|subform > form |
|Cut |---------
|Copy |
|Paste |
|Delete |
----------

f I click 'form' the list queries properly, but I don't want to have to make the user right click the subform inorder to have the query, not to mention this right click menu doesn't come up in the production version.

What is going on here? And how can get this to query? I have tried simply requering the list on click to no avail.

 

[boblarson]

A subform loads BEFORE the main form. So, what you should do is in the Main form's On Load event, put code to requery the combo on the subform:

Me.YourSubformControlName.Form.ComboNameHere.Requery

where YourSubformControlName is the name of the CONTROL on the main form which HOUSES the subform (not the subform itself).

 

[abbers_01]

Thanks Bob,
I ended up getting working on the Current event.
I didn't realize the subforms loaded first, thanks for the insight.