Complex forms and scripting in Access

Question

Hi, I am looking for some good tutorials on building complex forms in Access. In particular, how to get one ComboBox to populate with values based on the selection in another ComboBox.

Cheers!

Answer 1

The Access Developers Handbook by Litwin, Getz and Gilbert is excellent. There are several versions, here's the amazon link to the 2000 version.

Tony Toews's online Access pages are very good.

As is The Access Web: Limit content of combo/list boxes

Answer 2

Typically you would do something like that in an event on the ComboBox you are doing the selection on - probably the After Update event.

Then you would just update the values in the RowSource of the other combobox. Depending on the type, you could update the query/table, value list or field list it references.