Form for searching only

[Bandit]

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?

 

[Mark A. Sam]

What you are asking for requires too much time and effort for an answer
here. You really need a developer, however, an easy way around this is to
set the default view of your search form as a Datasheet and set the lock
properties of the textboxes or other editable controls to Yes. This will
prevent changes to the data. When the form is opened, the user can filter
any field by right clicking over it.

God Bless,

Mark A. Sam