Prevent enter key from inserting new record?

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

How do I prevent the enter key from inserting a new record after the last
field on the form? I intend on using the insert key and the + key, if I
ever figure it out...Thanks..Randy
 
When I want to control the insertion of a record, I prefer to use an INSERT
INTO SQL statement. Have you ever done this?

Here is a sample:

'Insert statement...
strSQL = "INSERT INTO [yourTableName]
(strPartNumber,strDocumentation,dteDocReqBeginDate) " & _
"values ('" & strPartNum & "', '" & strDoc & "', '" &
dteBgDte & "')"

CurrentProject.Connection.Execute strSQL

Let me know if this helps.
 
Tools --> Options --> KeyBoard -->MoveAfterEnter

I believe that this might be what your looking for. Under the tools options keyboard tab their is a setting to control enter key behavior.
 
No, that wasn't it. I need to totally disable the next record only using
the enter key. I want the enter key to stop on the last field of my
form..Thanks..Randy
 
Back
Top