Synchronize 2 combo boxes

  • Thread starter Thread starter Tarek Nassar
  • Start date Start date
T

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.
 
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
 
Back
Top