Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

access.Application.DoCmd.FindRecord

Status
Not open for further replies.

Voga

Technical User
Apr 30, 2003
28
US
Hi all. Thank you for visiting my thread. I need a help.
I open Access database from Excel form. How to make access.Application.DoCmd.FindRecord method to look for a record in specified field ONLY? In my case this is "lastname" field. How to specified this field in the following string that I tried and what its order of arguments:

Dim MySearch As String

MySearch = txtLName.Text
......
access.Application.DoCmd.FindRecord MySearch, acStart, True, acSearchAll, True, acAll, True

'this is what I have now. It's searching the record at all directions which I don't need. Where in the string above I can specified my "lastname" so it would perform the search only in "lastname" field?

Thank you



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top