How to "refresh" form

  • Thread starter Thread starter Chip
  • Start date Start date
C

Chip

Hi!

I have a form with a table and a query linked to it.
There is a list box on the form that gets it's vaule from
a table.

I also have a chart that gets it's vaule to graph based on
the what I choose in the list box. The chart is based on
a query with a criteria...[Forms]![Form1]![List4]

Where Form1 is the name of the form and List4 is the list
box.

The form does exactly what I want by graphing a vaule
based on what I choose from the list box. But problem is
that I have go into and out of design mode for it
to "update".

If I select a vaule from the list box I would have to go
into and out of the design mode to make the graph update.
Is there a way to make it update when I click an item on
the list? Or is there a way for me to make a button that
will update it?

Thanks for any help you can supply.

-Chip
 
Chip,

Private Sub List4_Click()
If Not IsNull(Me.List4) Then Me.Graph1.Requery
End Sub

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Back
Top