Search results

Ive sorted it now, turned out to be an idiot mistake by me. I changed the name of the search form from 'Search' and never changed the code to reflect that. When I ran the search it left the form open in the background and just pulled it forward for the next search. Thanks for the help...

I have a search form with a number of comboboxes. The user can select any option from as many comboboxes as they please to find the record(s) they want to track. It works fine on the first open - opens blank. It also works fine if you open, choose an option, but close the form. When you reopen...

I realized that pretty quickly and got rid of them all. Everything is working like clockwork now. Hopefully there wont be any last minute changes, other tha that possibility all I have left to possibly do is split it up and let people run free on it.

I think this is what you are tring to do: You could import the excel data you need into a table in access. Then using a combobox on your data entry form look up the data in the newly created table as a control for that field.

I have seen the DB that you currently have in another thread. You are pretty much set up for this already. You need to create a query that gets its parameters from your main form. In the query design view, in the criteria box for each category you want you need to put...

Wolff: The code is awesome. I have all my searches working like clockwork. Thanks for the help.

Thanks for the help guys but I have discovered a problem of my own making that needs to be fixed first. Lookups in tables and storing the ID rather than the data. Messed things up and I am going back through it all and rectifying my mistakes. Tiro: I used a bunch of resources that showed me...

I have searched for an answer but it seems that people are having my problem the other way round. I have created a simple 2 criteria search form that runs a query. It works perfectly if both fields are filled in and pulls the expected results. My problem is if 1 field is filled and the other...