Filtering one lookup list dependent on the entry of another

[luciegiles]

I have two lookup lists in a database tlkpLocality and tlkpWorkBase. I want the response in tlkpLocality to limit the options in tlkpWorkBase but don't know how to do this. Thanks.

[OldBirdman]

I'm not sure what kind of table or control tlkpLocality and tlkpWorkBase are. If they are comboboxes or listboxes, maybe this link can help: http://bytes.com/topic/access/insigh...mbo-list-boxes
If not, would you rephrase your question

[tuxalot]

Some examples of how to do this can be found by downloading this file:

http://www.candace-tripp.com/download/cascadecombo2k.zip

Other example downloads are here:

http://www.candace-tripp.com/utterangel.aspx

Hope this helps,

Tux

[mshmyob]

Check Post #2 here.

Hope this helps.

cheers,