Add a record to a subform

[Guest]

Hi there,

I run the following code on a button's click event:

Me.frmExpenses_sub!dtmDate.SetFocus

This goes to the first record in my subform, what I need is to then go to a
new record in my subform which is based on qryExpenses which goes back to
tblExpenses.

Can anyone help? I'm sure this is a simple thing.

Thanks,

JR

 

[Al Camp]

Johnny,
Me.frmExpenses_sub!dtmDate.SetFocus
DoCmd.GoToRecord , , acNewRec

 

[Guest]

Thanks, that really put me in the right direction. It didn't work with the
reference to dtmDate but when I just set focus on the sub form itself, it
worked great for both adding and deleting a record.

Thanks Al!

JR

Any other ideas?
--
www.brightfuture.ca/bright
My email address can be found on my site.

Johnny,
Me.frmExpenses_sub!dtmDate.SetFocus
DoCmd.GoToRecord , , acNewRec