Searching a lookup table from a subform

[Guest]

I have a main form for purchase orders and a subform for the order item
lines. I also have a table of "inventory items" to go into the order lines.
I would like to be able to search in the inventory items table from the order
lines subform inthe purchase order form. (I have about 3000 inventory items
to search - the item number is pretty useless, so I'd like to stick to
searching the description)

Thanks in advance for any help.

 

[Penguin]

If you are using a combo box to lookup items set its Row Source to a
query or SQL statement. Something like:

Select [ItemNumber],[Description] From [inventory items];

Set the Column Widths to 0,2

This should only show the description field.

Hope this helps.