cmd button to field

I have a database  called TOEWYS with table  TOEWYS with field HKNR and Form called INVOER.
How do I make cmd button on form INVOER
 to go to new record  
to the field HKNR
on the form INVOER ?
Who is Participating?
pcelbaConnect With a Mentor Commented:
Access 2007 has this button predefined in Command Button Wizard (Category "Record operations", Action "Add new record") you just have to add GoToControl macro into On Click event.
You just have to add Button to your form (in Design mode) and in the button's On Click event you have to call macro GoToRecord with record parameter = New and then you have to call macro GoToControl with parameter containing the name of your field (HKNR).

Hope you have Access 2007 but it should be very similar in older versions.
WIETIEAuthor Commented:
I have Access 2003, Can you please explain in more detail the parameter bit for field

The answer is in the question having higher point value :-) : 

The process of button adding and its click event definition is slightly different in Access 2003 but very similar to Access 2007.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.