When setting the "Enter key behavior" for a textbox in MS Access to "New record in field" the textbox accepts multiple lines, but does not save each line in a separate record (assuming the textbox is already linked to a table).

I need a code that creates a new record each time I press the "Enter" key in the textbox.

Any thoughts?

If you don't mind my asking...

What kind of data are you working with, and why would you like it setup this way? I would think that a combo box or other control may give you more flexibility, depending on what your desired outcome is.



Mike
EchoVue.com