Need 2 parameters to limit criteria on a report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gg - 07 Dec 2005 21:36 GMT

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

Reply to this Message

Douglas J. Steele - 07 Dec 2005 22:59 GMT

In the AfterUpdate of the first combo, put code to set the RowSource of the
other combo.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> If I have 2 unbound controls on a form, ie. num_no and types, how do I
> limit
[quoted text clipped - 10 lines]
>
> gg

Reply to this Message

gg - 07 Dec 2005 23:28 GMT

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!

> In the AfterUpdate of the first combo, put code to set the RowSource of the
> other combo.
[quoted text clipped - 13 lines]
> >
> > gg

Reply to this Message

Douglas J. Steele - 08 Dec 2005 23:21 GMT

Take a look at http://www.mvps.org/access/forms/frm0028.htm at "The Access
Web"

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> 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
[quoted text clipped - 22 lines]
>> >
>> > gg

Reply to this Message