Add New Record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Welly - 30 Sep 2005 11:43 GMT

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.

Reply to this Message

Ofer - 30 Sep 2005 12:22 GMT

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

Signature

I hope that helped
Good luck

> 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.

Reply to this Message