Filtering a report by a combo box

[Guest]

I have a currently-existing report, tied to a query. My goal is to allow
users to preview a report, filtered on criteria from a combo box.

The field I want to specify is, itself, a combo box. The data would exist in
multiple records, but be a finite list of information.

 

[Jeff Boyce]

Not sure I'm following...

Are you saying that the underlying field-in-table is a data type = Lookup
("is, itself, a combo box")? If so, you may be running into one of the
issues that argue against using the lookup data type!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Ugh.

What would be the recommended alternative?

Not sure I'm following...

Are you saying that the underlying field-in-table is a data type = Lookup
("is, itself, a combo box")? If so, you may be running into one of the
issues that argue against using the lookup data type!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff Boyce]

Check the mvps.org/access website for a discussion of the "evils of lookup
fields (in tables)".

First, before anything else, change the lookup field data types to whatever
the underlying ID field's type is /are. A lot of times this is a Long
Integer.

Next, please try paraphrasing what you want to have happen when someone
selects an item from a combobox that is loaded with ... ?!what?!

Regards

Jeff Boyce
Microsoft Office/Access MVP