Search results

Hi I have built a form but when i tab the cursor flicks from the first field to the fourth then third etc.... I want to tab so that it follows the first field to the second to the third to the fourth etc.... how can i do this?

Sorted... Thank you you are my guru!!! Jed

Thank you Thanks Mileophile, two last questions: 1) What if i want to search for just the bankers regardless of their positions? but still retain the ability to search for both. 2) How can i reset a seacrh form so that all the fields are blank ( i e New Search) jed

Thank you RichO for replying, Have another prob. What if there is no data in a table under one of the criteria e.g. drop down box displaying job type then choose banker to find the bankers in the db but it does not return bankers that have no data in another search criteria i.e. Position...

Hi I am still trying to create a search engine for my database that will allow me to produce results according to any of the input criteria ( Lastname, Currentfirm etc). Having looked at the dynamic query post i have decided to use Vb code to run the searches according to one or many of the...

I have created a form that allows me to define criteria for a query (using a macro tied to the drop down box within the form). I now want to add another drop down box that will allow me to add another criteria to the query thus refining the results. However i would like the ability to leave...

Hi I am new to access and need to create a multiple parameter query to search one table of data (Name, Job, tel number etc). I have managed to create individual queries I.e Job or name or Firm etc But i want to create a query in which i can input parameters for, say, job and firm Can this...