Can I create a form that will search a table for a specific record within the
table without changing the underlying table?  The tables have inventory for
parts.  I want to allow the mechanics to open a form and type in one of
several varaibles such as:  A part name or part number that will give them
the location of their part.  I do not want them to be able to change the
table.  I created a form using the form wizard but when it asks me what table
has the related info and I tell it, it automatically brings up the first
record in the table.  Also, if they put in a part name, it will only bring up
the first item in the table when if fact there may be several items with the
same name.  I want all items of the same name to appear and then they can
choose which one they want.  Any suggestions?