Access Access 2003 Search

F

funguse

Joined
Jun 8, 2007
Messages
1
Reaction score
0
Hello every one.
I've got a question that I can’t seem to find the answer to on here or any other forum.

What I’ve got at the moment is a database with x-numbers of tables and forms and a search form that allows the user to enter a specific string then select the table and corresponding text field on that form.

Code: 
Me.[subform].SetFocus 
Me.[subform].Form.[textbox].SetFocus 
DoCmd.[subform] Me.[searchString], acAnywhere


It then searches through all the records in that table and displays the first record it finds. It’s a simple form with a few list fields and a subform that gets changed depending on what form is selected in the main form.

Code: 
[/size][/font] 
[font=Times New Roman][size=3]Me.Searchthingy.SourceObject = "formName[/size][/font][font=Times New Roman][size=3]"[/size][/font] 
[font=Times New Roman][size=3]
What I’m trying to do is that a user can just enter a search string and it shows all the corresponding records (results) in either a form or a report.
An example is the search facility on this forum.


How would I go about doing that or has any one got example code they could post please?


Thanks
Mark
 
Last edited:
Back
Top