Find Control (2k)

[officespacer]

I'm using the standard find control because it makes the search code simpler than i could. however, i don't want it to use the default option, which is searching from the previous control. i want it to be set on txtdrawingnumber instead of screen.previouscontrol. so i tried doing this:

Private Sub Command73_Click()
On Error GoTo Err_Command73_Click

masterlist.txtdrawingnumber.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

Exit_Command73_Click:
Exit Sub

Err_Command73_Click:
MsgBox Err.Description
Resume Exit_Command73_Click

End Sub

but when i try this, i get the message "Object Required". is there another way of doing this?

[HansV]

What is masterlist? The name of the form? If so, replace it with Me.

[officespacer]

<img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30>

thanks hans

[officespacer]

just wondering... why doesnt specifying the form name work? is it just something w/ VBA that you have to do?

[HansV]

Specifying the form name is not necessary here, but in general, you would do it as follows:

Forms!masterlist.txtdrawingnumber.SetFocus

or

Forms("masterlist").txtdrawingnumber.SetFocus

The Forms collection contains all open forms.