Hi all,
First, sorry about the title. I accidently posted the question while I was typing the title.
So, I have a form with a dropdown box that when you select a product it populates a subform with that product information. For some reason I'm getting this error when I try to add a record via the Add record button that I coded. Here is the code it's telling me to debug. The weird thing is I use this same code for all my forms that are built almost identical and it works fine.
Private Sub cmd_add_record_Click()
Me.AllowAdditions = True
DoCmd.GoToRecord , , acNewRec
End Sub
What am I doing wrong? Is it the query I have for the subform? It connects two tables via the product name field.