Link to home
Start Free TrialLog in
Avatar of WIETIE
WIETIEFlag for South Africa

asked on

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 ?
Avatar of Pavel Celba
Pavel Celba
Flag of Czechia image

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.
ASKER CERTIFIED SOLUTION
Avatar of Pavel Celba
Pavel Celba
Flag of Czechia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of WIETIE

ASKER

I have Access 2003, Can you please explain in more detail the parameter bit for field

WIETIE
The answer is in the question having higher point value :-) :
https://www.experts-exchange.com/questions/24545567/cmd-button.html 

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