Question One form with 3 different options

Hi there

I am a newbie to access 2007. I would just like to know if it is possible for me to make one form with 3 different options i.e i have a start date and end date and a combo box. if the user enters only for the start date and end date , and clicks the run button, it must pull the query for that specific item and display the data in a report for that only. if a user selects items from a combo box it must show only data for that specific combobox selection. also if the user selects the start date and end date and combobox it must display for that selection.

As said before i am a newbie to access but i am catching on really quick. i would truly appreciate your help with an example .

Thanks again
Compu

Welcome to the forum,

In your criteria in the query I would ensure that you are selecting the Build Wizard to help you select the form and the controls, also the date fields on the form must be Formatted to a Date/Time format.

In the criteria do you also want the start date to be everything from the date to the end date period.

As for the combo box you would use the word
Like[Form]![FrmSearch]![ComboboxName]&"*"

thanks for your speedy response.

basically i have one report and this report must pull data based on the parameter selection in the form.

and yes i would only like data for that specific start date and end date.

your help is appreciated