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.
 

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

Similar Threads

If datapoint already exists populate form 2
Can't undo a form's TextBox entry that has a validation rule 7
Setting the focus to the first field on the form 1
Test which field has focus 4
Need combo box to refresh when moving to new record 2017 1
Unbound forms and dao recordset question 1
Focus set to sub-form when form first opened. 3
Cancel On Lost Focus Event 3

Back
Top