Modifying J Walkenbach's data entry userform

[rbl]

I have purchased the code for the data entry form from j-walk. I have
make a few small changes to the code. I am generally happy with the
form. However, when the enter key is pressed during the entry of a new
record. the form closes and returns to the spreadsheet database.
I would appreciates any suggestions on how to make the enter key
respond the same as the tab key; that is, move to the next control in
the form.

 

[ilia]

I don't remember what the Data Entry form looks like (been a while),
but if you set the textboxes' EnterKeyBehavior property to False, then
Enter will act as Tab. Right-click on the form control in question,
and select Properties from the pop-up menu.

 

[Dave Peterson]

You also may want to look to see if the Ok button's .default property is set to
true.

If it is, then hitting enter is like clicking that button.