Greetings
I'm getting the dreaded parameters error - not sure why
I'm trying to add a new line/record to a subform and I've checked for all the usual suspects and the query appears to be clean, but...
Here is the query
Code:
CurrentDb.Execute "INSERT INTO TblServiceLines (RefNum, ServiceDecision, ServiceType, PlaceOfService, ServiceCodeRange1, ServiceCodeRange2, ServiceQty, StartDate, EndDate) " & _
"SELECT [Forms]![FrmUnited].TxtRefNum, Me.TxtServDecision, Me.TxtServType, Me.TxtPlaceOfServ, Me.TxtCodeRng1, Me.TxtCodeRng2, Me.TxtQty, Me.TxtBegDate, Me.TxtEndDate;"
One additional piece of information... The button this query is attached to is in the subform but the RefNum value is called from a textbox in the main form..
Any insights would be greatly appreciated - I'm at my wits end with this project
Thanks