List box based off a querie. Unable to select record

[Sturgis76]

Looking for some help on a issue I haven't been able to solve.
I have a form used to create purchase orders. On this form I have a list box that is based off a querie to show the user all the other items ordered under the same purchase order number. I want the user to be able to click on the item in the list box and the form will go to that record. I tried to copy the code for a normal search box but end up getting a "type mismatch" error. The code is in macro builder and is as follows

search for record
object type Form
Object name parts order
record first


where condition= ="[id] = "&Str(Nz([screen].[activecontrol],0))

Thank you for your help

[davegri]

A bit of confusion here.

I want the user to be able to click on the item in the list box and the form will go to that record.

If the form is showing all the items in the current PO, it's already showing that record. Do you mean that you want to open a new form showing that item's details?

[Micron]

Is ID a number and a valid field for the condition? You are converting it to text.