Is it valid for a form to be based on a query which references something on the form?
I say no. After form open event occurs, load event occurs. That's when the form recordset should be populated by the query you are using. If your form control has a value in it at that time, you likely would be ok. If that gets delayed or is not present for any reason, you have a problem. If it's a combo, I don't see how it would work as a value would not have been chosen from its list. I think there are more reliable methods, like
- passing an open arg value in the form open command line or
- loading the records after user picks or enters a value in the control(s) that your query criteria needs or
- loading all records (not a fan of that idea unless recordset would be relatively small)then filtering based on same actions noted above
If I could get an explanation the sequence of what happens when a form opens,
that would also be helpful.
https://support.microsoft.com/en-us/...7-ce86553682f9
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.