lookup in table

[Guest]

I am creating a table with multiple lookup cells. What I want to be able to
do is specify the following:

If the value in the first cell is “architecturalâ€, then the lookup list in
the next cell is “architectural measuresâ€. If the value in the first cell is
“mechanicalâ€, then the lookup list in the next cell is “mechanical measuresâ€.

Could someone help me with this conditional lookup list?

 

[Van T. Dinh]

It is not possible in the DatasheetView of the Table AFAIK.

You need to use a Form for data entry and use the AfterUpdate Event of the
first ComboBox to dynamically filter the second ComboBox.

See The Access Web article:

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

If you are using LookUp Fields in the Tables, please read:

http://www.mvps.org/access/lookupfields.htm