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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to refresh other front ends

Status
Not open for further replies.

stuandwil

Technical User
Apr 16, 2004
24
GB
I have a form "Main" which runs from 2 Front Ends which list tasks outstanding. If a record is added from 1 front end what code will refresh so that the number of records in the second front end increments and shows the new addition. The form refreshes itself every minute and this updates the tasks outstanding list to show whether or not a user has passed off a job as completed, but does not show an added record. I realise closing the form and reopening refreshes all the record set but can it be done without closing and opening.
 
stuandwil

I am not sure about remote execution, but on each front end, in addition to Refresh, you can try a Requery.
 
me.requery did the trick, the second FE is more of a look only so it does not matter that the whole thing is refreshed.

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top