Find Button

[Guest]

I know this seems like another Find thread, however, after reading them, I am
more confused. Here is my problem:

I am desiring to add a 'Find' button Command. I use the wizard and the
'CTRL+F' window comes up when I am finished. I do not want this feature, I
only desire to limit the find to one field that is formatted thus: 000-00-0000


Any and all assistance is requested.

Thank you

 

[Ed Robichaud]

Well, 2 possible solutions.
1 - position the "Find" command button near your SSN field (the standard
Find dialog assume you want to start looking in the current (has focus)
control).

2. Use a combo-box locater control that has a control source of SSN and
Name, then on the After Update event, run code to find matching record on
your form. The combo-box wizard will write most/all of the code for you.

-ED

"(e-mail address removed)"