Tutorial :Complex forms and scripting in Access



Question:

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!


Solution: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


Solution: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.


Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Previous
Next Post »