I'm having problems with my DoCmd.GoToRecord,,acNewRec - it opens the form, but does not go to the new record and populate the fields with the data.

If IsNull(PurchaseMainList) Then Exit Sub
    DoCmd.OpenForm "PaymentsUnprocessedListF"
    DoCmd.GoToRecord , , acNewRec
Forms!PaymentsUnprocessedList!PurchaseID = PurchaseMainList  Forms!PaymentsUnprocessedList!PaymentDate = Date    Forms!PaymentsUnprocessedList!PaymentAmount = PurchaseMainList.Column(6)
    
DoCmd.OpenForm "PurchaseListF"
RequeryPurchaseMainList

Any ideas why this is happening?

Regards, Mark

---

Reply from Alex Hedley:

Try doing one thing at a time.
Does the first line work
DoCmd.OpenForm "PaymentsUnprocessedListF"
Yes, try the second as well. Until you find the one that doesn't.