I know this has been covered many times before but here goes anyway.

Being new to access i dont think i am doing to bad with my new database but i would like some help in setting up this form.

I have a database that has multiple tables and forms. Users work in the machines form and I want users to click on a button that opens a popup form with 1 field in it. I want the users to be able to enter a whole or part of a serial number, then press an OK button which returns them to the machines form displaying the correct record.

I hope this makes sense. Any help is most appreciated. I dont mind using VB or Macros. But I am not keen on using combo boxes. Do hope all this makes sense. Cheers

Suggest using an input box, you can enter all or part name or number in there and have it then list options or whatever.

I won't post the code, email me if you need it.

Col

[This message has been edited by ColinEssex (edited 03-25-2002).]