REQUERY or REFRESH

F

FGM

Microsoft Access 2002 Windows 2000
Need to refresh records in a form from another form. Actually, I have to do
this from two places. I am in a calculator form and trying to refresh
records in another form with only a main form. Then I am in a calculator
form and trying to refresh records in a subform of another form.

Any help is appreciated.

Thanks.
 
A

Allen Browne

Refresh saves the record. It does not load any other records that have been
added via a parallel process.

Requery reloads the form's records, so it does discover any other new
records. Because all records are reloaded, after a Requery you end up back
at the first record just as if you closed the form and opened it again.
 
F

FGM

how do I get it to requery from another form?

Allen Browne said:
Refresh saves the record. It does not load any other records that have been
added via a parallel process.

Requery reloads the form's records, so it does discover any other new
records. Because all records are reloaded, after a Requery you end up back
at the first record just as if you closed the form and opened it again.
Click to expand...
 
Top