new problem
hey thanks for the help it worked...but theres 1 more thing...
how can i got to a new record in a subform? the subfrm is located in a page, this is what i have right now but it doesnt work.
Private Sub cmdAddCustomer_Click()
Customer.SetFocus
DoCmd.GoToRecord acDataForm, "sfCustomer", acNewRec
End Sub
the subform is called sfcustomer, and the form which it is based is called fcustomer. i have tried both but neither seem to work