Update form

  • Thread starter Thread starter CAM
  • Start date Start date
C

CAM

Hello,

In in form called Dashboard I have charts using sql and text boxes, which is
based on query. When the user goes in and add data in another form called
formAdd I want the dashboard form to update, unfortunately I have to close
the Dashboard and re-open it then the charts and text boxes get updated.
That is a pain. Is there a way to have my dashboard updated automatically
when a user update the formAdd? Any tips will be appreciated. Thank you in
advance.
 
you can requery the dashboard form in VBA, as

Me.Requery

if you run the code from within the dashboard form, or

Forms!Dashboard.Requery

if you run the code from within another open form.

hth
 
Back
Top