Instant updating on form problem

[Stuart Green]

I am trying to write a simple system where staff can apply for leave. On the table where the dates are recorded is a field to record the approval that is initially blank. The staff manager has a continuous form built around a query that looks for all the records where the approved field is null. Against each record in this continuous form is an approval button that runs an update query to populate the approved field for that particular record with the message "approved". (so far so good). When the update is run, that particular record vanishes off the continuous form. Problem is I don't want it to vanish whilst the form is open in this session (there is also a button to email the approval for this particular record but of course this goes as well). It is OK for it not to be listed if the manager has closed the approval form and then re-enters. Any suggestions please?

 

[Stuart Green]

Thank you Pat, right once again!