Form/Subform Searching

Hi All,

I have a Find Record button setup in most of my forms in order to find
a specific customer's details. I have just noticed today though that
this search will only find the customer if it already has linked data
in the subform. This totally defeats the purpose of my search, which
is to find an existing customer's details in order to enter new data
in the subform.

I was wondering if there is a way, in the form/subform situation, to
find an existing customer and bring up their details and a new record
to be linked in the subform. Or must I resort to seperate forms???

This is my existing find record code from using the button wizard so I
don't actually understand it.
DoCmd.GoToControl "Surname"
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

The GoToControl I had to change from the generic wizard code which was
Screen.PreviousControl.SetFocus
and did not work.

This situation occurs for forms that are sourced from a query and
directly from the table. Using access 2000.

Thanks.