Query runs before On Open Event Procedure

[shuddle]

I have set an On Open Event Procedure to bring up a pop up building parameter form where a building number can be added. The main form has a query with [Form]![FM_Building_Parameter]![BldgCmb] in the criteria. The problem is the query is asking for the building number before the event runs to give me the chance to enter it.

I have other forms that this works in and I'm not sure why it isn't working in this one.

Any ideas?

Private Sub Form_Open(Cancel As Integer)


DoCmd.OpenForm "Fm_Building_Parameter", , , , , acDialog
End Sub

[ranman256]

It looking at the form that hasn't finished opening.
put the openform code in FORM LOAD event.

[shuddle]

That didn't work either. I misspoke. I don't have other forms that do this. I have reports. Maybe you can't do it in a form.

[aytee111]

You could have a pre-form, one that opens before the main form, where they enter the value.
You could have the field on the main form itself and requery the form after they enter.
You could have the query as a parameter that the user enters.