search in access

S

Samrasr

Hi hope someone can help me.

I have a form, on the form i want a create a box, when i click on the box a
find Dialog box appears just like the one when you click Edit and select
FIND. Every time i want to search for a name in all records i have to
deselect Search fields as formatted and click on for it to search all
records. I know all this, but a new user would not.

Can you please explain this in detail and in a simple mannor, i.e codes in
Visual Basic, etc.

This is the third time i have put thread in without success! So its a box
that appears and you type a text, number and it will find in all fields for
that. So if i type Ricky it will find Ricky in every Record..

Thanks, i wait in anticipation.


Ricky Samras
 
B

B. Comrie

Try writing your own, add a text box and button to your form.

Then try playing around with the DoCmd.FindRecord command

DoCmd.FindRecord Me.TextBox1, acAnywhere, False, acSearchAll, True, acAll,
True
 
Top