New Record when tab control is clicked

[steve1111]

Hello,

I am somewhat newer to Access so I am trying to accomplish this without VBA code.

I have a form [expense from] that has (3) tabbed controls on it. I want when i click on the second tab [Enter Receipt] for the page to GoToRecord - New. I cant seem to find the right place to put this macro, On Load gave me an error when my main navigation loaded and On Click made me click on the detail of the Enter Receipt tab rather than performing it when the tab was opened. Thanks for any help you can offer.

 

[Geotch]

can you upload a sample?

 

[steve1111]

Geotch, I think by trial and error i found i needed to use On Current, seems to be working like I want it to but i i see that results in errors elsewhere i will upload the db. thanks for the reply.

 

[pr2-eugin]

You could use Button's much neater !