Box that will open several records

[Guest]

How do you create a box or something of the sort that will pop up when you
open an access file, where you would type in a certain number and the records
that correspond with that number will open?

 

[Guest]

How do the records correspond to that number? Please be a little more
specific.

 

[Guest]

Look in Access help for 'FILTER' that seems to be what you are looking for.

Dorian

 

[Guest]

We want to be able to type in a serial number and after it is typed in any
records with that number will appear. But we want the box to type the number
in to appear when you open the database

 

[Guest]

I'm no expert, but make a query based on the table where the data is, in the
query criterial cell of the column SerialNumber, type Like[Enter the Serial
Number]

Base a form on this query and every time the form is openend, a box will
appear and ask you to type in the serial number, all records then displayed
in this form will meet your serial number criteria and no others will appear
unless I have totally misunderstood your request