synchronizing several combo boxes on a form

[David]

Hi,
I used a combo box to show the value of a field obtained from a query.
(i.e. the data source is set to a query.)
I then added 2 other combo boxes, with the intent to capture two other
fields from the same query.
My question is: how do I get the 3 combo box to synchronize to the same
record each time the query is invoked via a change in one of the 3 combo
boxes.
If the solution should require a VBA procedure, can somebody show me how to
write one for this task?
Thanks.
David

 

[Ken Snell [MVP]]

Check out these two articles at The ACCESS Web (I'm not sure which one you
want to use):

http://www.mvps.org/access/forms/frm0058.htm
http://www.mvps.org/access/forms/frm0028.htm

 

[David]

Your answers help solved the problem.
Thank you.
David