Form refresh

[JP Martinez]

How do you code a form refresh in Access.

thanks

-Pierre

 

['69 Camaro]

Hi, Pierre.

How do you code a form refresh in Access.

This depends upon whether you want to refresh the same Recordset that was
retrieved when the form was opened (or last requeried) or whether you want
the freshest data stored in the database. Use the Requery method instead of
the Refresh method if you want the latest changes from _all_ users. So, the
code would be:

Me.Refresh

- or -

Me.Requery

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[JP Martinez]

thanks a lot -that worked

Hi, Pierre.


This depends upon whether you want to refresh the same Recordset that was
retrieved when the form was opened (or last requeried) or whether you want
the freshest data stored in the database. Use the Requery method instead of
the Refresh method if you want the latest changes from _all_ users. So, the
code would be:

Me.Refresh

- or -

Me.Requery

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

['69 Camaro]

You're welcome!

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)