Macro to jump to new record

[kuebs]

I am really new at macros. Can someone tell me how to make a macro button for a form that will jump the user to a new record? My form opens up into existing records and they are getting overwritten. And the users can't seem to get the little buttons down on the bottom of the form.

 

[David R]

In code it's DoCmd.GoToRecord , , acNewRec after you open the form.

If you need to use a Macro, look at the list under 'Record' for the GoToRecord Action. One should be 'New'.

David R

 

[Graham T]

Kuebs

If you are wanting to restrict the user from editing previous records, maybe you could create a seperate form and just det this to data entry only.

Thus when the user opens, it will open at a new blank record.

HTH

 

[David R]

You can also open the same form as a Data Entry form, you don't need to copy the existing one. Look through the list of options you get with DoCmd.OpenForm.

David R

 

[kuebs]

I don't know where to find the DoCmd.OpenForm options. Just so you know even when I create a button and only use the button wizard functions, it says there is an invalid outside procedure.

 

[kuebs]

I have tried the button wizard to make a button that goes to the next record. But each time I hit the button, I get an invalid outside procedure. I don't get why the button wizard doesn't work.

 

[David R]

I don't know what that error means. From the archives I gather that it may be a problem with your installation of Access. What version are you using? Have you changed/reinstalled anything MS-Office related recently?

David R