I have an event procedure:
" Private Sub cmdFindName_Click()
On Error GoTo Err_cmdFindName_Click
Me![Last Name].SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
Exit_cmdFindName_Click:
Exit Sub
Err_cmdFindName_Click:
MsgBox Err.Description
Resume Exit_cmdFindName_Click
End Sub"
which brings up the Find and Replace box. Problem is the 'Look In' defaults to Last Name and the whole database - is there a way of adding fields to the 'Look In' box ?
alternatively how can i set the default field to the one on the form that the cursor is on ?
any ideas ?
regards
iono
" Private Sub cmdFindName_Click()
On Error GoTo Err_cmdFindName_Click
Me![Last Name].SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
Exit_cmdFindName_Click:
Exit Sub
Err_cmdFindName_Click:
MsgBox Err.Description
Resume Exit_cmdFindName_Click
End Sub"
which brings up the Find and Replace box. Problem is the 'Look In' defaults to Last Name and the whole database - is there a way of adding fields to the 'Look In' box ?
alternatively how can i set the default field to the one on the form that the cursor is on ?
any ideas ?
regards
iono