Lookup Column

[Ken Hutson]

Hi Group,

I find that I would like to populate a combo box with it's choices dependent
upon the value of another field on the current row.

For example, suppose I am in a table on a particular row in a field with a
lookup column. The contents of field "UNITS" on the current row could be
either "metric" or ""english". If it's "metric", I would like the combo box
to display a list of choices. However, if the value in "UNITS" is
"english", I would like a different list of choices. Is this something that
is simply not done? How can I accomplish this?

Regards,
Ken Hutson
San Antonio, Texas

 

[John Vinson]

Hi Group,

I find that I would like to populate a combo box with it's choices dependent
upon the value of another field on the current row.

For example, suppose I am in a table on a particular row in a field with a
lookup column. The contents of field "UNITS" on the current row could be
either "metric" or ""english". If it's "metric", I would like the combo box
to display a list of choices. However, if the value in "UNITS" is
"english", I would like a different list of choices. Is this something that
is simply not done? How can I accomplish this?

It cannot (to my knowledge) be done in a table datasheet - but IMHO
table datasheets should never contain combo box fields at all, and
should only be seen for debugging.

It's perfectly standard on a Form, however! You need a small amount of
VBA code; for a sample, see

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

 

[Kenneth Hutson]

Thanks John Vinson,

Due to my inexperience, I try and see how things work at a primitive level.
Hence, datasheet view. I will explore this approach with the form object.

Regards,
Ken Hutson
San Antonio, Texas