Add New Record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a subform that I am using for Data Entry however instead of adding a
new record, as my command button states, it writes over the record previously
entered.
If I use the subform on it's own it works fine, when this form is in the
'master' form it doesn't work.
 
What code are you using?
You might need to set the focus to the sub form, before running a command to
open a new record

Me.SubFormName.SetFocus
DoCmd.GoToRecord , , acNewRec
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inconsistent Add Record Performance 1
Add new record to master and subform at the same time. 16
Form and subform weirdness when linking to SQL Server 2005 via OD 2
How to detect navigation 5
Need combo box to refresh when moving to new record 2017 1
how to goto last record, add new record 14
Refresh Subform Current Record? 3
SubForm does not accept focus when adding a new record ? 4

Back
Top