Search Form Based on Combobox and Date range

[Stika]

Hi,



Im not sure if im googling the right stuff but I Have a form....It has a combobox where I select a Transport Carrier. I then enter the date range in 2 seperate fields and need to create a search button...but I want to bring up all the records by that Transport carrier field and inbetween the date range I have input and want it to spit out to a report.

Is this possible or Im just not googling right?

[June7]

Several ways to accomplish. Do you use VBA or macros?

For one method, review: http://datapigtechnologies.com/flash...mtoreport.html

Another is WHERE CONDITION argument, something like:
DoCmd.OpenReport "reportname", , , "[Transport Carrier]='" & Me.comboCarrier & "' AND DateField BETWEEN #" & Me.boxStart & "# AND #" & Me.boxEnd & "#"

Is Transport Carrier field a text or number? If it is number, remove the apostrophe delimiters.

[Stika]

Hi,

Thanks for getting back to me...I found a solution this morning...im pretty sure its the same thing you have...Thanks for you help