refresh form from the code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to refresh form2 from the form1 and I do not know the syntax.
When updating current form the syntax is clear

Me.Refresh,

but how to refer to another form? I tried

Forms("form2").Refresh

but this does not work.

thanks
 
I am not sure what the difference between these two is but when I put a
button on the form2 and into event click i put

Me.Refresh
then I get exactly what I need.
Now I want to get to this without clicking on the form2

any thoughts?
 
From "help"...

In an Access database (.mdb), refreshing records only updates the data that
already exists in
your datasheet or form. It doesn't reorder records, display new records, or
remove deleted
records and records that no longer meet specified criteria. To perform those
tasks, requery the records.

Note In an Access project (.adp), the refresh and requery actions both
requery the records.

HTH
 
Thanks guys for your replies, finally I have realised that my request did
make sence and I have resolved the issue using event method - on get focus.

Sorry and thanks for your help
 
Back
Top