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

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?
 
K

Klatuu

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.
 
M

mezzanine1974

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
 
K

Klatuu

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top