Run queries every time form opens

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have designed two update queries, each of which updates a separate date
field [CurrentTermExp] and [SendNoticeBy] in my table [tblAgreements].

I would like to set up an event so that every time the form [frmAgreements]
based on the table gets opened, both queries run and all records are updated.

I'm pretty sure I need to write an event, but I'm not sure which event to
use. Any suggestions would be much appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple selection combo box 11
Dlookup - autofill control based on combo box choice 5
Only one check box at a time 1
Opening form unexpectedly closes other form 0
Access Open Form with WhereCondition 6
Cascading Form Management 2
Error message 2950 when attempting to save a record 3
Counting multiple memberships 1

Back
Top