Query by Form to search

[pkj7461]

Hi,
I was working on this form to search based on criterias. I added a combobox with the value lists of <,>,=. Now, I also have a text box control to enter date.
How would I bind the value lists to the text box control?
Like If I want to retrieve all records for anything >1/2/2008....
How would I achieve this? Any help will be appreciated.
Thanks,
PKJ

[MindBender77]

Hi,
I was working on this form to search based on criterias.
PKJ

First, write a query that contains the dates and the records associated with thoses dates. The criteria for date must come from the form itself.

Next, run the query after the date and <,>, = have be select. Ideally, you want the results to show in a subform if more than one record will be displayed.

You may also want to use a combo box for the dates as well. For example: Search for records between the date in combobox1 and combobox2.

[pkj7461]

Hi,
If you could provide me an example of this, it would he helpful.
I did try something like this, but no luck.

IIf([Forms]![Search Form]![cboperator] Is Null Or [Forms]![Search Form]![txtdate] Is Null,Null & [Forms]![Search Form]![cboperator] & [Forms]![Search Form]![txtdate])

Thanks,
Prasanna.

[MindBender77]

Hi,
If you could provide me an example of this, it would he helpful.
.

The simplest way is to make a select query allowing the first column to be Date. The other columns can be any other information you need.

In the criteria under the Date column enter something like this:

Criteria: [Forms]![YourFormName]![ComboBox] & [Forms]![YourFormName]![YourDateTextBox]
 

Hope this Helps,
JS