Inquiry box

[sue]

I have a table with 100 records 10 columns.
Post Down Past
100 a b
200 c d

I want a box to come up for me to enter Column Post = 100 and get all the
other column information on that record. How do I do that?

 

[Jeanette Cunningham]

Assuming you have the table open,
right click in the post column and choose Number Filters.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Tom Wickerath]

Hi Sue,

Are you looking to do this directly in the table, as Jeanette's reply
suggests, or do you want to create a simple search form? If the latter, try
this sample:

http://www.accessmvp.com/TWickerath/downloads/customdialogbox.zip


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________