one table, one form, multiple fields

[billyraum]

Hello everyone,

I was working on a database several months ago and I came across this forum while troubleshooting. I had to abandon the incomplete project for some time now, but I am back and ready to get this thing up and running!

My database used to be comprised of lookup tables and other things for each of the fields in my main table, but I have recently scratched that idea for simply using list boxes.

My main problem, I believe, is with my form. I am trying to have two combo boxes, a beginning date and end date, and a keyword text box, all used as criteria in a query.

Seems pretty simple, and I actually got the keyword text box to work, but the combo boxes and between dates critiria return all records.

Can someone double-check my work? I'm sure it's just a simple error, but I will attach a stripped-down database for anyone to look through.

Thanks ahead of time for anyones help, it is greatly appreciated!

 

[Jon K]

I have added a separate combo box for the Title field and changed the criteria of the query.

The user can now search for any text string in the Details field. And when the txtDatein text box is left blank, all the Date field records will be returned.

Hope it is what you wanted.


Note: Date is a function name. Better avoid using it as a field name.
.

 

[Smart]

In your query in the details column you are usein the samefield to search on as for thr title thats why nothing is returned.
if enter the same value in the title into the detail field in the table it works

 

[billyraum]

Thanks for your help, i really appreciate it!

After I posted this problem, I continued to peruse the forum and found gromit's search form (http://www.access-programmers.co.uk...53&PHPSESSID=b3131a56adacaff2cc0ba3fea93e5180) And I modified that to fit my database and I have things working again. But with your response I understand what I was doing wrong! Thank you!