Add New Record

  • Thread starter Thread starter Gator
  • Start date Start date
G

Gator

I created a Form / Subform using Access wizrd. I want to be able to go to a
new record on the Form when I hit enter on a control on the subform - which
will goto a new blank record on the Form & Subform. Do I do this in Code and
how would I do this? My VB skills from 1-10 (10=expert) is about 3-4.
 
Here is what I'm doing...I have a popup where I select a vendor name. The
name is copied to a textbaox and then the popup is closed...from there I want
the focus to go to the account field in the subform. The subform is a
datasheet type...does this matter? Here is the code I'm using. I get an
error that says "compile error: method or data member not found"

Private Sub List0_Click()
Forms!form1.VendorName = Forms!VendorListPopup.List0.Value
DoCmd.Close acForm, "VendorListPopup"
Forms!form1.SetFocus
Me.PayablesDetailsSubform.SetFocus
Me.PayablesDetailsSubform.Form!Account.SetFocus
End Sub
 
The first reply I sent to you deals with another issue i accidentally sent to
you. maybe you can help me there...thx
 
Back
Top