How to focus on recordset which has already entered by form?

  • Thread starter Thread starter mezzanine1974
  • Start date Start date
M

mezzanine1974

I have an "enter data" form which is bounded to a table. When I enter
the new record for all textboxes, "enter data" form insert the data to
the table instantly, then move to the new record to be fill in.

What i need is to force the Access to focus on the recordset I already
insert. I mean, after insert data, form will focus again back to
already entered data, instead of new record.

Am I clear?
 
If you have the Data Entry property of your form set to Yes, change it to No.
Also set the Cycle Property to Current Record.
 
Hello Klatau,
Thanks for your interest. I did what you recommend. But it does not
provide me what i need.
Because, in that way, i can not insert data. Cycle is always going on
while i am pressing enter. I defined BeforeUpdate event on that form
and it is never running. If only i roll the mouse, BeforeUpdate
running.
What I need is to insert the new record and after that Access will not
promt me to a new record. So, I will be still seeing all received data
in the text boxes!
May be, i can not explain myself.
Thanks
 
The other thing that can affect this how you have the Move After Enter set in
your database options - Tools, Options, Keyboard tab. Set it to Next Field.
 
Back
Top