Different "Find" behavior in Access 2000 and 2003

[Paul Fenton]

We have a network application that's been developed using Access 2000,
but is runnning under 2003 on the client workstations. When we open
the "Customers" form, the Last Name field is selected and highlighted.
Under the 2000 version, the Find & Replace form opens with the "Find
What" field blank. However, under the 2003 version, the highlighted
last name from the form is inserted into the "Find What" field of the
Find and Replace window.

Is this normal behavior in Access 2003 and if so, is there a way to
cause the Find and Replace form to behave as it does under Access
2000?


Paul Fenton

 

[Guest]

Humm. Never noticed that before. Seems to default to the first field in the
Tab order. I know how to do thing like set the Match and Search but not the
Look In.

Here's what I do for commonly searched fields. I put a little button with a
binoculars icon on it next to the field to search. Then I put the following
code behind the button. The SetFocus puts the focus on the field to search.
Then the Find dialog box comes up.

Private Sub butFind_Click()
On Error GoTo Err_butFind_Click

Me.ASA.SetFocus
DoCmd.RunCommand acCmdFind

Exit_butFind_Click:
Exit Sub

Err_butFind_Click:
MsgBox Err.Description
Resume Exit_butFind_Click

End Sub

 

[Paul Fenton]

I do the exact same thing Jerry in addition to setting the focus to
the Last Name field in the OnCurrent event, since that's the field
they search on 99.9% of the time.

I did discover that if I un-highlight the last name by moving the
cursor, but leaving it in that same field, the Find & Replace form
opens with the Find What field blank. If I add a line of code to do
the same thing, that should solve the problem.


Paul Fenton