Field Record Source

[autiger58]

Hi Everyone:



Is it possible to have a record source for a field that is based on the input in another field in the same form?. EX: Field A is a drop down list for COUNTIES. Field B is for SUBDIVISIONS. When someone enters ACME in field A as a COUNTY when focus is the moved to field B, ONLY the subdivisions in ACME COUNTY are available to be entered in Field B (from a linked table containing ONLY Acme County Subdivisions).

Is this possible and if so could you point me in the direction of how to do this please????

Thanks
Michael

[CJ_London]

yes - the principle is called 'cascading combo's'

see this link for one example

http://www.access-programmers.co.uk/...d.php?t=275155

[autiger58]

Thanks Ajax. I believe I actually understand how to make this work in my situation from the link you posted. I didn't know what it was called so I didn't know what to search for. Thanks again.

Michael