I don’t really know what is going on here.
I am trying to open a form and now it keeps asking me for a parameter value:
Service.[Service_ID]. The thing is I have no idea where, in the code, Access is looking for this value.
It seems to be doing this prior to the onset of my form load… before any form events happen (e.g., when I walk through
the code, the parameter popup appears before any of these events are kicked off: Open → Load → Resize →
Activate → Current). Prior to any these aformentioned events kicking off, I make attempts to open a form like so:
DoCmd.OpenForm "00160_Clone_Service_Level_Contacts", acNormal, , , acFormAdd, , strArgs
As soon as I step through the DoCmd.OpenForm line, a message box pops up asking for the parameter value, shown
So, it’s looking for Service_ID from the service table, but the form is unbound. So when does it check for this value?
And how can I stop it from doing this?