My Sync. Combo Boxes work, BUT, HELP!

[KADL]

I used the standard AfterUpdate coding on the first box and no row source on
the second box. The second box dropdown shows the proper data upon data
entry and displays properly after selection.

The problem is the second box is blank for all records later on. Each box
has Column Count 2 and Column Width 0";2". The table shows that the bound
column is populated.

I am using Access 2002. What am I missing?

Thanks!

 

[Marshall Barton]

I used the standard AfterUpdate coding on the first box and no row source on
the second box. The second box dropdown shows the proper data upon data
entry and displays properly after selection.

The problem is the second box is blank for all records later on. Each box
has Column Count 2 and Column Width 0";2". The table shows that the bound
column is populated.

You need to run the AfterUpdate code in the form's Current
event too.

Note: If the form is open in Continuous or Datasheet view,
some records other than the current record will display a
blank, but, other than appearance, everything will work.

 

[KADL]

Thanks for responding.

It is a continuous form so I solved the problem by creating an additional
locked combo box for the same control source for displaying the data.

I narrowed the synchronized box to just the dropdown arrow and tried to
superimpose it over the dropdown arrow of the new box, but it was hidden
behind instead. So, I have both dropdown arrows side by side and it will do.


Thanks.

 

[Marshall Barton]

It is a continuous form so I solved the problem by creating an additional
locked combo box for the same control source for displaying the data.

I narrowed the synchronized box to just the dropdown arrow and tried to
superimpose it over the dropdown arrow of the new box, but it was hidden
behind instead. So, I have both dropdown arrows side by side and it will do.

The "standard" approach is to use a locked text box instead
of a locked combo box. However, using a second combo box
has some advantages because it can have an unfiltered row
source so it shows any value. Just make sure that the
locked combo box's GotFocus event (re)sets the focus to the
filtered combo box.

Hmmm, I've never heard of using a second combo box before,
but it sounds like it may be an ideal approach ... I'm
going to have think about this some more. Thanks for
posting your solution.