SYNCRONIZE DATA INTO TWO COMBO BOX ON A FORM

[Fred's]

Hello There,

Does someone can help me from A TO Z for syncronizing data into two
combo box on a form.

Have two seperate table, one "suppliertbl" and the other table named
"Reteknumbertbl"
and like to create two combo box on an existing form.


When I select a supplier name into the first combo box, I want the
pre-defined number to appear into
the second combo box without selecting any info into the second combo
box.


Does someone knows how to do this? Either with a macro or Visual basic
application (VBA)

Thanking you for your help!

Fred's

 

[Van T. Dinh]

See the following Microsoft Knowledge Base articles:

http://support.microsoft.com/kb/209576

http://support.microsoft.com/kb/209595

and The Access Web article:

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