How to create a 'search' button?

[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!

 

[Rick]

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

 

[C Tate]

Many thanks - will try it out!

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