Synchronize 2 combo boxes

[Tarek Nassar]

hey all,

i made a relation between 2 combo boxes using the "REQUERY" statement in the
VBA, it all worked well untill i loaded the form to be used as a sub-form in
another main form. when i reach the second combo box it requests the data i
should be taken from the first combo box to be written in a parameter box.

please advise on how to make it not to.

tanks.

 

[Maurice]

You have to rewrite the reference to rquery not directly to the first form
anymore but you have to reference the main form as well now.

So it coul look something like this:

forms!mainformname!subformname.form.controlname.requery

replace the form and controlnames accordingly