synchronize combo boxes

[Suzanne]

I am pretty new to Access - and self taught for the most part. I am trying
to synchronize combo boxes. I have been able to use the example on the
Microsoft Website and get it to work - except that the combo boxes remain
unbound and then when I do select a control source - my form turns up blank.
Obviously I'm doing something wrong - can anyone help? Note - I didn't use
the VBA method - I used the macro method as I couldn't get the VBA method to
work at all (I'm not too familiar with VBA in Access).

 

[Arvin Meyer MVP]

I am pretty new to Access - and self taught for the most part. I am trying
to synchronize combo boxes. I have been able to use the example on the
Microsoft Website and get it to work - except that the combo boxes remain
unbound and then when I do select a control source - my form turns up
blank.
Obviously I'm doing something wrong - can anyone help? Note - I didn't
use
the VBA method - I used the macro method as I couldn't get the VBA method
to
work at all (I'm not too familiar with VBA in Access).

Try looking at the sample database at:

http://www.accessmvp.com/Arvin/Combo.zip

 

[Suzanne]

Thanks for the link - I had kind of figured that I may have to do an
"afterupdate" to the unbound lists - is there no way that I can synchronize
the combo boxes and yet still have them bound to a particular field?

Thanks again.

 

[Arvin Meyer MVP]

Combo and list boxes have 2 kinds of binding. A column binding, which
controls which column (usually the first) of the combo or list you are
reading when you say in code: Me.cboComboName, and a field binding which can
bind to a field in a table or query.

Lookup combo and list boxes are always unbound to the field, because if one
bound them to a field, every time a lookup was done, it would change the
data.