Hey ChipR,

Thanks for the response.

So just to get this straight:
1. Every time a user makes a change to one of their orders (I assume I'll use the control's AfterUpdate event), the value is inserted into the "holder" table.
2. The hidden timer form will check every X seconds to see if there is something in the holder table. If yes, issue a MsgBox where CurrentUser = Admin.
3. Delete the...

Hi all,

I have a DB which is designed to have 1 admin and several users on at the same time. The users and admin all work with the same form, called frmOrders, which is a continuous form that lists out, in real time, orders which the users enter. I have a timer form called frmTimer running (hidden) in the background which updates frmOrders every 2 seconds and checks if a new order has been added. If yes, a MsgBox pops up on the admin's...

The user who sees the popup message will click "OK" and it goes away. I'm not sure if that answers your question properly? A message should pop up when the chkAcknowledged control's value changes to True/-1. The code should be able to identify the record where the Acknowledged checkbox value changed.

Hi all,

I've got some code in a form (frmTimer) which checks another form (frmOrders) every 2 seconds to see if any new records have been added. If yes, then a MsgBox pops up on the admin's screen. I'd like to add some more similar code to frmTimer to check if a particular field (chkAcknowledge d) in frmOrders has been checked off, and if yes, issue a popup MsgBox. However - the caveat is that in this case I need to be able to identify...