Sounts like you are using a continous form. On a continuos form there is
only one set of controls - they are merely displayed multiple times. So when
the rowsource query is filtered to limit the list to entries matching
another control, this filering affects the combo on all of the visibile
rows. Since the selected value is presumably not in the list as currently
filtered, the control seems to be empty.
To create the *effect* of a synchronized combo in a continuous form create
another textbox control, include the display column of the combo in the
Recordsource query of the form (join the foreign table and drag in the
column). Position and size the new textbox so that you can place it
directly over the combo box allowing only the down-arrow portion of the
combo to show.
Create a GotFocus event for the textbox that only does a SetFocus to the
combo.
This will create the effect that you are wanting - the correct display value
will always show even though the value itself might not be fit the criteria
that is in effect based on the current record.
Here's a KB Article that explains the problem
ACC2000: Combo Box in Continuous Form Shows Incorrect Data
http://support.microsoft.com/default.aspx?scid=kb;en-us;208866
Here's a link to my sample database that offers several different
alternatives for displaying this type of data including the technique
described above:
http://www.daiglenet.com/msaccess.htm
--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.
I'm trying to limit a second combo box based on the value in the
first one.
I've tried to apply the article on "The Access Web" but the value in
the 2nd combo box of the next or previous record gets wiped out.
How can I correct this?
Thanks.
