Filtering a tables fields

[Tim Stephens]

I have two tables; one main table and on table used for combo box lookup.
There are two fields in the main table that are restricted to valves in the
other table. After a valve is selected in the first field I want the combo
box for the second field to only display data based on the first field. Here
is an example of the second tables data:

A 1
A 2
A 3
B 1
B 3
B 5
etc.

If the first field in the main table is "A" I want the combo box for the
second field to only display "1, 2, 3".

Any help on this would be appreiated.

 

[John Vinson]

On Mon, 24 Oct 2005 11:02:03 -0700, Tim Stephens <Tim

I have two tables; one main table and on table used for combo box lookup.
There are two fields in the main table that are restricted to valves in the
other table. After a valve is selected in the first field I want the combo
box for the second field to only display data based on the first field. Here
is an example of the second tables data:

A 1
A 2
A 3
B 1
B 3
B 5
etc.

If you're doing this on a table datasheet... you can't. Table
datasheets are VERY limited; and putting a Lookup Field into a table
is generally frowned upon - see
http://www.mvps.org/access/lookupfields.htm for a critique.

If you use a Form with a combo box, it's easy: see the second example
at

http://www.mvps.org/access/forms/frm0028.htm

John W. Vinson[MVP]

 

[Tim Stephens]

Thanks John. Will a combo box work if the form is using datasheet format?

Tim

 

[John Vinson]

Thanks John. Will a combo box work if the form is using datasheet format?

I think so, but I so rarely use datasheet format that I can't say for
sure.

John W. Vinson[MVP]