Synchronize 2 combo boxes. Cant get it to work

[DouglasLB]

We have been trying to follow the instructions on other threads on linking comboboxes so the choice in the first box determines the choices available in the second combobox.

ComboBox 1 is called ListeningPost and the columns in the table are ListeningPost and LPidentifier. The second ComboBox is called FeedbackSource and the columns are FeedbackSource and LPidentifier.

My form is called IssueEntry.

The tables are named TblListeningPost and TblFeedbackSource.

How should the Row source Property be written for each combobox and how should "after update" event in combobox 1 be written.

Thanks inadvance for all the wonderful Help we are about to receive!!!!

 

[JerryDennison]

In your dependent combobox you should have the following in the criteria of the common (between the two comboboxes) field:

Like Forms!FormName!Combobox1Name & "*"

By adding the '*' you can force all available choices if no selection is made in the first combobox. This is useful if the two can be mutually exlcusive.

Next in the GotFocus event of the second combobox(not the AfterUpdate event of the first) use the following:

...
Me.ActiveControl.Requery
...