DoCmd.BrowseTo with variable as datamode

[jeffhanner]

I'm using this part of the code to open a form in a subform. I want to assign a variable to the datamode which is based on the username.
When I declare the variable as a string then the error is Type Mismatch

Dim ACMode As String
ACMode = "ACformReadOnly"
' m_Callform is the name of the form, which is passed via the Function

DoCmd.BrowseTo acForm, mCallForm, "frmSCD.NavigationSubform",[SNUmbr]=" & TempVars!TempSNumber, "", ACMode

Note: Normally I just have this:

DoCmd.BrowseTo acForm, mCallForm, "frmSCD.NavigationSubform",[SNUmbr]=" & TempVars!TempSNumber, ""

Which creates an edit mode.

I could use a conditional statement here, which is based on the user name, but I have too many screens for that.

Any Suggestions?

[June7]

Missing first quote mark in the WHERE CONDITION argument.

Also, can't pass "ACformReadOnly" as a string to DataMode argument. It expects a numeric value and it cannot evaluate "ACformReadOnly". This is just a string of characters and triggers the mismatch error.

acFormReadOnly is a constant with value of 2 so either:

ACMode = 2

or

ACMode = acFormReadOnly

As far as I can tell, ACMode is not an intrinsic constant but I would not use ac as a prefix.

[jeffhanner]

I'm sorry to respond late, however, the information you provided was very helpful and I was able to resolve the issue.

Thank you.