Refreshing Data

[adillpickle]

When refreshing a form after entering data into various fields of that form, is there a way to keep it from going all the way back to the first field of the form? Is it possible to refresh and the cursor remain in the cell you currently in?

[RuralGuy]

Before Refreshing, save the ActiveControl.Name and set the focus to it after the refresh.

[adillpickle]

Before Refreshing, save the ActiveControl.Name and set the focus to it after the refresh.

Thank you, RuralGuy. I have to admit that I am a bit of a novice. How would I go about this in my database?

[RuralGuy]

How are you refreshing the form now?

[adillpickle]

The "Refresh All" button on the toolbar

[RuralGuy]

I reread your first post. Why do you need to refresh your form after only entering values in your controls? What does that accomplish? Are you familiar with code at all? You probably can't change what the toolbar does but you could create your own button on the form that does what you want.

[adillpickle]

I reread your first post. Why do you need to refresh your form after only entering values in your controls? What does that accomplish? Are you familiar with code at all? You probably can't change what the toolbar does but you could create your own button on the form that does what you want.

There are multiple people who enter information in the database, sometimes at the same time. The operators refresh to ensure that the data is saved. That may not be necessary. I'm not sure you read in my last post when I said that I was somewhat of a novice to Access, but yes, I am familiar with code on a basic scale.

[RuralGuy]

Maybe you could simply set the Refresh interval short enough to satisfy your requirement and avoid code. It might be worth a try. If you would prefer to implement your own method and need assistance, just post back here.
https://msdn.microsoft.com/en-us/lib.../ff836021.aspx

[Missinglinq]

First off, refreshing doesn't save data! Moving off of a Record or off of a Form or closing a Form saves data.

Secondly, refreshing records only updates the data that already exists in your datasheet or form. It does not display new records or remove deleted records.

Lastly, as Allan suggested, you can set the Refresh Rate by going to Options - Advanced. The default rate is every 60 seconds...and I really can't imagine needing to do it more frequently...your users would have to do it constantly, rather than entering data.

[adillpickle]

Thanks for your help, RuralGuy. I really appreciate your help.

[adillpickle]

Thank you for the clarification, Missingling

[RuralGuy]

Linq,

If you follow the URL I posted in post #8, MSDN suggests that a Refresh *does* save data. I could be wrong here because I thought it didn't save data too.

The Refresh method immediately updates the records in the underlying record source for a specified form or datasheet to reflect changes made to the data by you and other users in a multiuser environment.

[Missinglinq]

I believe the term 'updating,' here, doesn't mean updating the Records, i.e. saving the data, but 'updating' what is actually displayed in the Form, which is, of course, the purpose of Refreshing.

Of course, I could be wrong!

Linq ;0)>

[RuralGuy]

They chose an interesting selection of words to explain it. Maybe some day I'll do a test.