Hi,
I wrote a Sub to run "Find and Replace" menu command on Access 2000.
It worked fine except SetFocus didn't work. It changed position from
time to time. I need the Focus always set at [Find What:] field
Here is the Sub:
'Find What: Need Code to SetFocus here???
'Look In: current field only
'Match: Any Part of Field
'Search: All
DoCmd.DoMenuItem acFormBar, acEdit, 9
SendKeys "{Tab 1}{Up}{Enter}{Enter}"
Can anyone provide SetFocus code?
Thanks