By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,060 Members | 1,266 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,060 IT Pros & Developers. It's quick & easy.

Event Trigger on Save

P: n/a
I have a form that I am using Condiftional formatting to create a
dashboard to indicate if there are records for each weekday of the
selected week. I have inserted requery commands on AfterUpdate events
of the fields, but the nature of the lookups that I am using for the
conditonal formatting need to be requeried once the record is saved.
Is there a way to trigger a requery when the save button is clicked? I
would think that it would be useful to recalcuated formula fields at
the same time.

I am using Access 2003.

Mike

Feb 14 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Mike wrote:
I have a form that I am using Condiftional formatting to create a
dashboard to indicate if there are records for each weekday of the
selected week. I have inserted requery commands on AfterUpdate events
of the fields, but the nature of the lookups that I am using for the
conditonal formatting need to be requeried once the record is saved.
Is there a way to trigger a requery when the save button is clicked? I
would think that it would be useful to recalcuated formula fields at
the same time.


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Use the Click event of the Save button:

Private Sub cmdSave_Click()

' save the data

' then do the requeries

End Sub

If the form is bound then use the Form's AfterUpdate event to do the
requeries.

Private Sub Form_AfterUpdate()

' run the requeries

End Sub

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQ/IjkYechKqOuFEgEQIF/QCeJqiasM0OHO2fHEo8SDYmdVPZQNwAoJSl
uVkAzu1PIcEMQ1Qwj2/eq9LS
=DbTt
-----END PGP SIGNATURE-----
Feb 14 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.