Linked option boxes

[dumb]

Hi all,

Useless at access, so hopefully simple question. Have a form with 2 drop down boxes. Options in second box dependent on selection in first. This is working fine, but only once. Problem is, if you change the selection in the first box, the second does not update to reflect what should be the changed options. Any ideas?

dumb.

 

[Mudface]

You need to requery the second combobox from the AfterUpdate event of the first.

There's a more sophisticated example available for download here (Cascading Combobox):-

http://www.candace-tripp.com/access_downloads.htm

 

[dumb]

Excellent - just what i needed.

thanks...dumb