Need 2 parameters to limit criteria on a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I have 2 unbound controls on a form, ie. num_no and types, how do I limit
the types to only those types that are related to the num_no and pass these
to a report. (i.e. if num_no=1, then the only available types=A,B; if
num_no=2, available types=A,B,C). Currently, the tables being referred to
for each control are independent, and the combination of these 2 controls
(what the user is selecting from these 2 combo boxes) is what I need to pass
to the report.

Thank you in advance. :-)

gg
 
In the AfterUpdate of the first combo, put code to set the RowSource of the
other combo.
 
Could you please be more specific as to the syntax I need to use in the
AfterUpdate event? Are you talking about adding a query to limit the
selection in a where statement? Sorry.

Thanks!
 
Back
Top