Adding a search function into switchboard

[mic907]

What is the best way to implement a search function into a switchboard? I need this search function to allow a user to check a database for specific names, so that they do not enter duplicates. Thanks in advance for all advice

 

[lightray]

I think you would want to do it on the form, where the name is entered. use it in the beforeupdate event.
Edit: Use a Dlookup

 

[mic907]

how do i do that? Sorry if this is a dumb question, but I'm completely new to access

 

[Dreamweaver]

Go Hear http://www.access-programmers.co.uk/forums/showthread.php?t=97434 Look At Post 8 That my get ya started

 

[dervly]

Hey I had the same problem. What solved my problem was to run what is known as a parameter query. Here you would simply create a select query. Using design view insert all the field os your table you wish to appear. Under the one you wish to search, for example surname, put [please enter surname]. To allow this to enter in a form from you switchborad simply create a form based on this query and run a macro to open this form.

 

[lightray]

how do i do that? Sorry if this is a dumb question, but I'm completely new to access

Here is a good thread, but there are plenty around. enter dlookup in the search function, preferably on Forms
http://www.access-programmers.co.uk/forums/showthread.php?t=118037

 

[mic907]

Hey I had the same problem. What solved my problem was to run what is known as a parameter query. Here you would simply create a select query. Using design view insert all the field os your table you wish to appear. Under the one you wish to search, for example surname, put [please enter surname]. To allow this to enter in a form from you switchborad simply create a form based on this query and run a macro to open this form.

It would be really great to hear how to do all this. Could this possibly run a search and display the search results, then allow a user select a record and immediately go to it?

Thanks again to all that have replied, I still need to take a look at all the links but I really appreciate the help

 

[mic907]

any suggestions?