Creating a find/search facility

[Julia]

Hi

What wouyld be the best way to acheive this...

I want to be able to put a search button on the switchboard where you can type in an ID and then it returns the relevant record, either highlighted in the table or on a seperate tab.

and if it doesnt find anything, return a message.

Thanks

 

[statsman]

Try this:

http://www.access-programmers.co.uk/forums/showthread.php?t=176023