Opening bound form via macro or docmd

[mdnuts]

I have a bound form that normally is opened via macro. Very straight forward just has the following in the where.

 [userID]=[Forms]![Home]![txtSelectUser]

I'm trying to open the same form via doCmd.

DoCmd.OpenForm "frmUserInformation", , , "UserID=" & Me.txtProblemID

I've msgbox'd the txtProblemID and the correct ID is being passed. Where I fall into an error is on the frmUserInformation's onLoad event which uses the ID form the frmUserInformation.txtUserID box. The error I get is "Syntax error (missing operator in query expression '[fldUserID]='."

strEndMonth = DLookup("fldDateExpiration", "qryUserExpirationDate", "[fldUserID]=" & Me.txtUserID)

What I've narrowed it to is the timing between the docmd.openform and the onload of the form. I've tried changing the onload to be on activate - and it just opens empty.

Any ideas how to get the docmd to open the form correctly before the onload tries to fire?

 

[bob fitz]

Have you tried using the On Current event of frmUserInformation's

 

[mdnuts]

Same error - missing expression, which works fine doing a macro open.

 

[bob fitz]

Perhaps you could parse the required value using the OpenArgs argument of OpenForm and then refer to its value in your OnLoad event

 

[mdnuts]

hmm, i haven't used that yet. let me research into it.

 

[bob fitz]

hmm, i haven't used that yet. let me research into it.

Let us know if you need any help with it

 

[mdnuts]

been giving it some thought. I'm thinking the result would be the same. I could just as easily assign a dim to what's passed via the txtUserID.

What I probably need to do is unbound the form and set each location that calls it to do it via vba instead of macro.