I have a large inventory table where every item has a stock number, which is an autonumber.
I want to search for the item by stock number and have a number field where the stock number is entered, and that displays a subform with details of that stock item.
However it does not work! I get a data type mismatch! How do I search for an autonumber?
Robert
I want to search for the item by stock number and have a number field where the stock number is entered, and that displays a subform with details of that stock item.
However it does not work! I get a data type mismatch! How do I search for an autonumber?
Robert