Modifying J Walkenbach's data entry userform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rbl - 10 Dec 2007 20:07 GMT

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.

Reply to this Message

ilia - 10 Dec 2007 22:00 GMT

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.

> 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
[quoted text clipped - 3 lines]
> respond the same as the tab key; that is, move to the next control in
> the form.

Reply to this Message

Dave Peterson - 10 Dec 2007 22:37 GMT

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.

Signature

Dave Peterson

Reply to this Message