synchronize combo boxes

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).

"Suzanne" wrote in message
...
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
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

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" wrote:

"Suzanne" wrote in message
...
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
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Suzanne" wrote in message
...
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" wrote:

"Suzanne" wrote in message
...
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
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com