Retrieving data

[martyn]

how do i search my database for an entry that put in
myself. Eg, click a search button, enter a surname, then
have access search for and display that record?
Many thanks

 

[Arvin Meyer]

how do i search my database for an entry that put in
myself. Eg, click a search button, enter a surname, then
have access search for and display that record?

Have a look at the search example databases on my website:

http://www.datastrat.com/Download/Search2K.zip

is one of them. Also have a look on the Access Web for another example which
builds a search string:

http://www.mvps.org/access/forms/frm0045.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access