Changing the criteria on the fly in a field

[Thompyt]

I have a query [By Field] and its fields are called [Field_ID] and [Field_Name].



I would like to have a Combobox in a form to select the [Field_ID], that displays the [Field_Name] and run the [By Field Report] with that selected [Field_ID].

[orange]

Have you tried
Using the combobox wizard and make the query the rowsource?

Make the size of the ID field 0 -so it doesn't display.
see this for intro and other combobox info

[June7]

Options for report:

1. report Filter property can have an expression that references the combobox

2. dynamic parameterized query http://www.datapigtechnologies.com/f...mtoreport.html

3. VBA code that constructs filter criteria and passes it to report when it is opened
DoCmd.OpenReport "By Field Report", , , "Field_ID=" & Me.comboboxname

[Thompyt]

Thanks June7. I did it the way shown in the weblink. Works now, but need to start a new thread.