Invalid Bracketing

[jdwm2310]

Hi Guys,

I get a invalid bracketing of name. Could you please help.thanks
stLinkCriteria = "[Employee Table (test).Employee Information]=" & "'" & Me![Employee Information] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormReadOnly

Exit_Command8_Click:
Exit Sub

Err_Command8_Click:
MsgBox Err.Description
Resume Exit_Command8_Click

End Sub

 

[jebry]

Hi!

You need brackets around the table name and field name separately:

stLinkCriteria = "[Employee Table (test)].[Employee Information]= '" & Me![Employee Information] & "'"

hth
Jeff Bridgham
bridgham@purdue.edu