How to create a 'search' button?

  • Thread starter Thread starter C Tate
  • Start date Start date
C

C Tate

I have created a small contacts database. I would like to share this with
other users. I want to create a 'search/find' button on my startup form but
I don't like the normal 'find' button as I don't think it is very intuitive
for very inexperienced users. Does anyone have any suggestions for other
possibilities? I would definitely like to see one or two examples so if
anyone knows of any relevant sites I'd appreciate hearing about them!
 
I have a text box labeled "Find Ref#" with the following in the after update
code:


Private Sub FindReference_AfterUpdate()
On Error Resume Next

' Find the record that matches the control.
DoCmd.GoToControl "Reference"
DoCmd.FindRecord Me!FindReference

' Clear FIND combo box
Me!FindReference.Value = ""
DoCmd.GoToControl "InstallDate"

End Sub
 
Many thanks - will try it out!
Rick said:
I have a text box labeled "Find Ref#" with the following in the after update
code:


Private Sub FindReference_AfterUpdate()
On Error Resume Next

' Find the record that matches the control.
DoCmd.GoToControl "Reference"
DoCmd.FindRecord Me!FindReference

' Clear FIND combo box
Me!FindReference.Value = ""
DoCmd.GoToControl "InstallDate"

End Sub
Click to expand...
 
Back
Top