Box that will open several records

M

mat

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?
 
M

mscertified

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

Dorian
 
M

mat

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
 
M

MikeJohnB

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
 
Top