go to new record in subform using a macro

[JSD]

Hello,

I was wondering if there is a way to go to a new record using a macro. I need this because I'm trying to use function keys to trigger commands instead of mouse click. I had this working in VB onclick of a button in the subform using DoCmd.GoToRecord , , acNew. This same command does not work in the macro. I think it is because I have to specify the form in the macro, but specifying the main form gives me no result and specifying the subform I get an error that says "frmwipin_plantone" is not open. Can anyone help me to work around this?

Thanks,

Jeremy

 

[Aqif]

I think it will be worth to first create a action to set focus on the control and then run new rec macro. So your macro will have two actions

GotoControl "Your Subform Name"
GotoRecord ..etc

Hope it helps


Cheers!
ÙÇãá