>Hey All,
> I'm trying to develop a form will give me the capability to simply pull the form up and either within a list box or grid, display updates in my main table from two other tables. For example, I would like to see if accounting on the third floor has posted any money to to a client's account that is entered by customer service on the seond floor. I would like to see this as it happens, sorta real-time updates. We are on a LAN.
>
>Does anyone have any clues?
>
>TIA
>
>Jeff T.
If you date/time stamp your transactions, this should be fairly easy. I would create a parameterized view of the tables of interest and use a timer on the form to fire a requery() as often as you want to see updated information. The underlying assumption is that these tables have a datetime field.
Mark McCasland
Midlothian, TX USA