Search results

Ok, I think I got it working ok now.

Once I added "and len(me.[ComboName])>1 then" to the combo box Code, I get results back, but not all results. I'm assuming I need some more coding to the check box and text results, but I see a "len" statement. Any ideas?

What about the check boxes and the text boxes?

OH ok. so that simple change will fix it? One day I'll grasp this foreign to me language! Now, how badly do you want to beat me up for being such a newbie?

I'm lost. I'm sorry. I didn't understand this post. I've included my most up to date database with the code you gave me to try fix it. Can you look at this and tell me what's wrong?

I tried just modifying my "on click" event for the "clear" button by putting following code and I end up with the same issue as before (no search results even with a blank form. What am I doing wrong? Private Sub ClearForm_Click() Me.[cmbNCTool].Value = "" Me.[cmbNCDivision].Value =...

so putting that at the end of what I had for my "on click" event would take of that then? I notice in the example you just posted for me, it has CurrentDb.QueryDefs("Query1").SQL = "SELECT [Tooling Information].[NC Tool #], [Tooling Information].[NC Division], [Tooling...

I'm trying to learn the coding better. Could you post what was the line of code before and after so I can see the difference.

ok, now is that code in the "on click" event procedure or somewhere else?

Yes it is. Please explain what to do to fix that, or what I was doing wrong. Thanks.

KeithG... No problem... Thanks for all your help once again. I'll post it here as well.

KeithG Here you go. I have the one zip file with the clear button on it that won't give any search results now. And I have another zip attached that has the original file before I added the clear button and the code. Hope this helps.

I'm trying to create a search form with drop down boxes to select criteria. I would like a "Clear Form" button that removes any data on the form to start a new search with. I have the following command in an "on click" event. But when I use this, it does clear the form. But from then on out, I...

Yes, after clicking on the clear/reset button on the form and it having all empty boxes on teh form, and then submitting the search form. I get an empty search results form that opens. I've tried deleting the clear code itself in the database, but I still end up with no results in the search...

Only bad thing I find about the Button Command Wizard option is that when the form is closed with information in the combo boxes etc, it keeps that info and the "clear" function won't work next time it's opened.

All the boxes were blank. I think I found a simple work around. Using the Button Command Wizard, under Record Operations, Undo Record seems to clear the form just fine without any errors.

If you add this line of code. Private Sub ClearForm_Click() Me.[cmbNCTool].Value = "" Me.[cmbNCDivision].Value = "" Me.[cmbToolMaterial].Value = "" Me.[cmbProfile].Value = "" Me.[cmbToolType].Value = "" Me.[cmbProfileType].Value = "" Me.[cmbBoardThick].Value = ""...

Here's a copy of the file without adding the code. This allows the search to work.

Here's my file. I have no idea what I did to cause this. I swear all I did was add that button and the lines in the On_click event procedure

hmmmm now I got it to clear the form. But now the "submit" button doesn't produce any records? What did I do?