Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update forms

Status
Not open for further replies.

billheath

Technical User
Mar 17, 2000
299
US

I have a continuous form. The underlying data can change very rapidly. The only way to update the screen is to close the form and then reopen. The form is based on a query. I have tried to use the requery method on a command button to no avail. Any suggestions would be greatly appreciated!

Thanks,
Bill



 
Have you tried me.requery followed by me.refresh?

Beir bua agus beannacht!
 
Thank you, Yes, I had put both statements in . However, I forgot that I had an "exit sub" statement that is activated under certain circumstances. I just added the statements again before the Exit Sub and it worked. I appreciate your help.
Bill
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top