show new info added to table

[billyw]

hi..

firstly i'm not that great with access so what i may be asking is well
beyond my understanding of the product.

i have 1 table and 2 forms.
1 form is used to input data the other is used to view that data and make a
couple of clicks to show completion of a job.
requery is set on a timer to update forms.

when new info is added or change made is it possible to have an alert,
nothing fancy, just a simple alert of some sort to show the change on the
form..

thanks in advance

 

[[MVP] S.Clark]

Assuming a multi-user app, the Entry form for User1 has no idea that User2
has the View form open. So, you've already discovered the Timer and On
Timer, which you can stick with to perform a requery of the data.

Assuming that the data has an autonumber, you can compare the last known
number to the current number, and when there's a difference, open a msgbox.
Or, just a simple count of the records in the table may be enough.

 

[billyw]

thanks very much for that..

i'll have a look through the help files and try and sus this out..

again thanks