Can't find the field '|1' referenced to in your expression

[Dave14867]

Hello all,

I have a form that I want to open to a specific record then a drop down item is chosen.

The Code is shown below.

Private Sub CmbConsequense_AfterUpdate()

If CmbConsequense.Text = "Termination (Complete Termination Form)" Then

On Error GoTo CmdTerminate_Click_Err


' _AXL:<?xml version="1.0" encoding="UTF-16" standalone="no"?>
' <UserInterfaceMacro For="CmdCloseForm" xmlns="http://schemas.microsoft.com/office/accessservices/2009/11/application"><Statements><Action Name="CloseWindow"/></Statements></UserInterfaceMacro
' _AXL:>
' Docmd.OpenForm "frmlTermination", acNormal, "", "[EmployeeID]=" [&EmployeeID], , acNormal
DoCmd.OpenForm "frmTermination", acNormal, , "", "[EmployeeID]=", [&EmpoyeeID], acNormal

End If


CmdTerminate_Click_Exit:
Exit Sub


CmdTerminate_Click_Err:
MsgBox Error$
Resume CmdTerminate_Click_Exit
End Sub

Specifically it is the Docmd line that is the issue.

If I put a button on the form and use the wizard to open and link it to an EmployeeID, everything work fine but I want it to work when the text in the drop down is selected. If I convert the button from a macro to vb the error occurs.

Can someone tell me what is wrong with the Docnd line? The line below is highlited in Red and was generated when the button was converted.

Docmd.OpenForm "frmTermination", acNormal, "", "[EmployeeID]=" [&EmployeeID], , acNormal

Thanks

[Micron]

Could be a few things.
You actually have a field in a table or query named &EmployeeID ? bad idea.
You have no concatenation character to add the [&EmployeeID] field. - "[EmployeeID]=" & [&EmployeeID]
You're using an invalid value for the window mode - acNormal is not a window mode but acWindowNormal is.

Don't provide zls (zero length strings - "") as argument values. Just type the comma as you did for DataMode argument.

EDIT
If you're thinking that wrapping something in brackets [&EmployeeID] is the equivalent of Evaluate (as in Excel vba) I don't think that works in Access.

[pbaldy]

For starters you need to concatenate the value:

Docmd.OpenForm "frmTermination", acNormal, "", "[EmployeeID]=" & [&EmployeeID], , acNormal

I'm wondering if the ampersand inside the brackets was meant to be outside.