Best Search form to use?

[YNWA]

Hi, I want to put a search field on my form.

The "find" option in Access does the job ok, but its a bit complicated and awkward for the users to use.


Is there a simpilar way of having a search field on a form ,to search say Surname of a table, when you click search that record is displayed ready for editing?

Ideally to have the search field in the header part of the form, then the searched record display below in the main part of the form. The field surname could have mulitple records so best way to do this and also see all records for that name search ?

Thanks
Will

 

[ajetrumpet]

best way is a filter. something like this:

button onclick()

me.filter = "[contactfield] = me.boxatthetop"
me.filteron = true

another way is the findrecord() method, but you can only flow through one rec at a time and never more than that. it has findfirst() findlast() findnext(), and so on.

 

[YNWA]

Will the filter allow me to enter a surname into my search box, it search the table for that name. What happens if I have more than 1 person with the same surname?

 

[pascaly]

Not sure if this is helpful, but I use a combo box with auto-expand on, that way, the user starts typing the name, it auto-completes, then if there is more than one person with that surname, all they have to do is select the name from within the partially completed list. My combo has about 400 people in it and it works fine.

This is in my header, then, when the user selects a name, the form is linked (via PersonID) to show that person's details.

 

[John Big Booty]

Have a look at the Cool Search Tool here

 

[YNWA]

Have a look at the Cool Search Tool here

Thanks for that. Its a great tool but I think its a bit too advanced for what I need to achieve.

My DB is going to have 1 user, with about 400 records in it (all employee names), she is going to search for an employee's surname and when the record is found, add 1 line of info to the form (the date of training was complete).

That is all.

I think the filter may be the best bet, as its pops up enter surname, searchs the table and pulls back the first record matching that surname, if two or more entries are there, is the only way to view the next entry to click the > icon on the scroll bar at the bottom?