The enter button does not select the command button.

[ariansman]

I have created a form to enter data into a table. I want the user insert the data and go to the next record by simply pushing the Enter button on the keyboard. I made a button and put this code in the “On Enter” part of the command properties :


Private Sub Command394_Enter()
DoCmd.RunCommand (acCmdRecordsGoToNew)
End Sub


Firstly, is the above code correct?



I push the Enter button after the last data is put into the form, but it only changes the selection among the form records and the command button is neither activated nor works.

Secondly, how is this problem solved?


Thank you

 

[missinglinq]

Wrong event! 'Enter' refers to 'entering' a Control, such as a Textbox, not pressing the <Enter> key. Use the OnClick event and drop the parens around the command:

Private Sub Command394_Click()
 DoCmd.RunCommand acCmdRecordsGoToNew
End Sub

Also, do yourself a favor; after placing Unbound Controls on the Form, before doing anything else, change the name from that that Access assigns to it to something meaningful! No one else will have a clue as to what Command394 is supposed to do, and in three months, neither will you!

Linq ;0)>

 

[ariansman]

dear missinglinq,
tnx for ur time,
i put it in the “OnClick” part of the command properties. but pushing the <enter> button still changes the selection among the form records, while no record is saved on the referred table. could you instruct?
rgrds

 

[missinglinq]

The code given above will move to a New Record when the Command394 Command Button is clicked. Assuming that your Form is Bound to a Table or Query, the Current Record will be Saved. With Bound Forms, a Record is Saved, automatically, when you

• Move to another Record
• Close the Form
• Close Access itself

You do not need to explicitly Save a Record in Access; it is done, automatically, as detailed above.

The <Enter> Key has nothing to do with any of the above. As I explained above, the OnEnter event is completely separate from the <Enter> Key. To prevent Access from moving to another Record, when you hit <Enter> after filling the last Control with Data, in Form Design View

• Go to Properties
• Go to the Other Tab
• Change the Cycle Property from All Records to Current Record

Linq ;0)>