Hi, I have a form that utilizes a listview controller, the form is used by three different users, i would like to have the information dynamically refreshed each time a user enters information. Any help is greatly appreciated.
One way to do this is to create a table that contains two date/time fields. The first date/time field would represent that a record was added or deleted from the "master" table. The send date/time field would indicate that a record, in the "master" table, was edited.
When your form opens, open the table and read in the 2 date/time fields and set them equal to public variables. In the OnTimer event of the form, check to see if either one of the date/time public variables are less than the ones in the table. If so, then either requery the form (if records were added/deleted) or refresh the form (if records were modified).
In the AfterInsert and AfterUpdate events of the form, you will need to update the table with the appropriate date/time values.
Example,
Table:
dtmRequery ... Date/Time field
dtmRefresh ... Date/Time Field
Form Module:
Dim mdtmRequery as Date
Dim mdtmRefresh as Date
Dim mrst as ADODB.Recordset
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.