How to bind a dynamic drop list to a table

[DavidArchibald]

Hi there

I have a form which all but one controls are bound to an underlying table.

On the form I have two drop down lists.

The first is a list of categories. The second is a list of subcategories.

The Categories drop down is bound to the Categories field (surprise, surprise .

I've added some VBA to the form so that the sub-categories displayed are limited to those that are linked to the Category (ie by CategoryID).

The form works fine except I can't save the results of the second drop down to the underlying table.

How to do I save the selection from the second drop down to the table?

I'm new to Access although I've had a bit if experience with VB and Excel (which I prefer!)

Cheers

David

 

[LittleSmudge]

As long as the subCategory combo box ( what you call a drop down list ) is Bound to the subCategory field in the table what you discribe should work fine.

In form design view, click on the subCategory combo box and check that the "ControlSource" property contains the field name for the subCategory.



'ope-that-'elps

G LS