Form refresh

6

'69 Camaro

Hi, Pierre.
How do you code a form refresh in Access.
Click to expand...

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.)
 
J

JP Martinez

thanks a lot -that worked

'69 Camaro said:
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.)
Click to expand...
 
Top