List Box Search using Macro

[Graham T]

I have a form named "frmSearch". This form contains only a listbox [List0].

The unbound listbox uses the Row Source of:
SELECT tblPayroll.strEmpID FROM tblPayroll;

I have created a macro named "mcrSearchListBox" using the actions "OpenForm". The action argumants for this are:

FormName "frmPayroll"
Where condition: [strEmpID]=[Forms]![frmSearch]![List0].[Column](0)

I have attached the macro to the On_Click event of the listbox.

What I intend to happen is when the user selects the value from the listbox, "frmPayroll" should open containing the corresponding value [strEmpID].

What is actually happening is the following error message "Undefined Function '[Forms]![frmSearch]![List0].Column]' in expression.

Can anyone shed any light on this?

I know I can perform the same action with no problem using VB, but I need to also demonstrate this action using a macro.

TIA

Graham