stock id to stock name

[dinobfc]

i have two seperate tables, Stock and sales. if i type the stock id number into the box in the sales form i want to bring up the name of the stock item which is stored in the stock table alongside the id number in a seperate text box in a form, i understand i need to use a query but am unamware of what to put into the criteria. Please HELP!

 

[Mile-O]

If you use a combobox with two columns you can let the user select the item and they'll never know you are storing the ID.

To answer your exact question, though, you'll want to have a look at the DLookup function in the Help Files.