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!

Refresh a form that was minimized on desktop

Status
Not open for further replies.

Fireman1143

IS-IT--Management
Mar 5, 2002
51
US
I have a basic In/Out form which on some workstations the user(s) will minimize it from their desktop all day. I have located the front-end in it's own folder on the c: drive of the workstation.

Is there a way to have the form refresh when it selected from their tool bar? The complete application is one form and one table and the only changes are a drop-down which is In or Out.

Thanks
 
So I quess you want to requery the combobox. On the OnActivate event of the form put:
Private Sub Form_Activate()
Me![Combo2].Requery
End Sub

Substitute your combobox name for Combo2.

You could also close the Access Application on their computer after a designated amount of minutes. If you search the Access forums, you'll find how to set the timer option to check for activity.

Also, one table? Is it normalized? Mind posting the fields?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top