Event Trigger on Save

[Mike]

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

[MGFoster]

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-----