Neil

Essentially very simple

1)you make the serial number text box a queryfield and put a button on the
form to search.  make the rest of the forms fields datafields from the
database and Bob is your uncle.

or 2)You could make it more automatic and remove the button and set each
other field to display the information it is meant to be displaying where
(using filter) the serial number equals the serial number at the top of the
form from your access database.  Ask me for help at
adam.harding@ltsbasset.co.uk

I would recommend 1) to get used to it and then after you have got it
working start working on 2).

Cheers Adam

Sorry to sound stupid buthow do you change a text box to a query field and
can you also help me set up the button ?. I have a button on my form now but
dont know how to program the button. Im new to this and really want to get
this form working. Thanks a bunch for your help. Cheers !