Search results

Ill try it and I will let you know thanks for the help.

If IsNul loop would prob be the way to go but would I put the IsNul for the form. I dont know what to check for in order to use the IsNul statement.

I have created a Database that includes a search engine that allows a user to search for 20 seperate categories and for each category they search simultaneously the result will have everything they searched for. I have set up the form which results to display this information using combo boxes...

thanks alot ill try it out hopefully ill get it too work.

I know I have replyed to myself twice now but Id like to draw attention back to my Question. When I am running a search and I get results in either a form or a table, when there are no matches for the search how do I go about checking for this. Once I do this I will have an error message...

The first part worked but could someone be more specific on how I could check for a blank record so that I can have an error message pop up.

Thanks for your help does anyone else have any suggestions

When I run a search and it brings up the results in a table how could I exclude the new record. My other problem is that when I run a new search and there are no records found I would like it to display an error message instead of just going to the one blank new record. If I eliminate the new...

Thanks I will try that

I know this may seem like an easy and trivial problem I am having a hard time solving this minor problem. When I maximize a form all forms that I go to afterwards are also maximized, I would like to keep each form to its original set form. Does anyone know how to do this, I am sure the answer...

Thanks DCX

I posted this on another board hopefully someone can help me here. I want to search for item in a table by selecting values in more than 1 combo box. once I select somthing from either both combo boxes or dont select at all I want it to search accordingly. As of right now I can only search...

Does anyone know how to make a form load up with blank combo / text boxes every time?

I havent been using access for that long so excuse this question if it seems confusing or stupid.

Does anyone understand what I am saying here. If not I could try to clarify.

I have a form with three combo boxes and one text box. There is a command button labeled search. This form is linked too a table and each box is linked to a certain field. Now what I want to do is if someone selects one field I want it to just search for that one. If someone wants to search...