filter

[peterbowles]

I am trying to open a form like this

Dim filter As String

filter = [EmployeeNo] = vNum

* vNum is a global Variable which hold the employee number when the user signs in

DoCmd.OpenForm "frmInvoiceLines", , filter

does not work

Any help would be great thanks

 

[Mile-O]

Filter probably isn't the best variable name to make as it is an object property in Access and, therefore, reserved.

strFilter would be more appropriate.

Dim strFilter As String 

strFilter = "[EmployeeNo] = " & vNum

DoCmd.OpenForm "frmInvoiceLines", acNormal, , strFilter