docmd.openform where condition

[Gina]

I am once again having syntax issues with the following statement. I have tried all variations of single ticks and quotes, HELP !!!!! I can get the two statements to work separately, but when I add the "AND" it fails.

The "RecordLock" field is a yes/no field.

stLinkCriteria = "[RecordLock]=No AND [Analysts]='" & StaffUserID() & " ' "
DoCmd.OpenForm stDocName, , , stLinkCriteria, , acWindowNormal, "Edit"

Thank You
gina

 

[wazz]

if StaffUserID() is a field on your form and is also a number then you don't need quotes for it:
stLinkCriteria = "[RecordLock]=No AND [Analysts]=" & StaffUserID()

- the brackets make it look like a function??

 

[Gina]

StaffUserID() is a function

 

[Gina]

I got it; too many quotes

stLinkCriteria1 = "[RecordLock]=No And [Analysts]=" & StaffUserID()