I added a refresh button to an ADP form. Every time I click the button, it takes me to the first record in the table. Is there a way to refresh and stay in the record currently being viewed?
Thanks for your help.
David

Refresh through ribbon button, no way, unless customized ribbon and can be done through VBA.

What would the code be if done through VBA?

These are the steps:
1. Save the PKId of the current record in view in a variable, Tempvars perhaps.
2. Refresh the form.
3. Goto, seek, find the the PKId you save in step 1.

What are you refreshing? You could open the form with only 1 record.

Thanks for your response. I have added the refresh button so others on the network can see the changes whithout closing the form or going to another record. When the refresh button is clicked, the data re-posts to SQL Server and others are able to see the updates.
For instance, when a CSR enters an order for paper, the paper purchasing agent needs to see the information at her desk. I'd like for the CSR to be able to click the refresh button without the form reverting back to the first record on their list. Some CSRs have as many as 50 records active on the query, so if the refresh button is used, the view reverts back to the first record on their list.
Hope you can help with being able to show me code that works.
Thanks in advance.
David

Is the paper purchasing agent another person form the CSR? If so, there should be a refresh button on that list.

This is what I meant on my first post, disregard if this is not what you want

this worked. thanks!