Combo Box Criteria Range

[fluffyxtera]

I have a report that opens from a form. This form has two combo boxes "cboVenOne" and "cboVenTwo" and a button that says run report. I want the query to pull up the ranges of vendors between those two combo box selections. I am assuming I would use a CoCmd.OpenReport with a where command. Any help would be appreciated.

[rpeare]

in your vendor name criteria put

[VendorName] between forms!formname!cbovenone and forms!formname!cobventwo

Assuming this is an alpha vendor name description

If you want a query that will run if the vendors are left blank or if only a single vendor is present you can also do that with formulas

[orange]

rpeare,
Welcome back, haven't seen you for a while. Hope all is well.

[rpeare]

been an extremely busy 6 months or so and all of a sudden I had a slow day!