Prev: Self linking tabel in editabel query
Next: publish option is greyed out in access 2007
From: sue on 6 Apr 2010 17:22
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?
From: Jeanette Cunningham on 6 Apr 2010 20:13
Assuming you have the table open,
right click in the post column and choose Number Filters.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"sue" <sue(a)discussions.microsoft.com> wrote in message
news:ABAE2FEB-17EC-4956-B052-883FE25631D5(a)microsoft.com...
>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?


From: Tom Wickerath AOS168b AT comcast DOT on 7 Apr 2010 01:26
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/
__________________________________________

"sue" wrote:

> 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?
 | 
Pages: 1
Prev: Self linking tabel in editabel query
Next: publish option is greyed out in access 2007