Update Form

[Robert P.]

I have a form who record source is a query. On the form
is a cmd button when it is clicked it updates the
underlining query.

When I click the cmd button I want the form automatically
update (and show the changes) after the query is updated
but I tried to requery and refresh but the only way I can
update the form is to close and open it.

Any ideas. Thanks.

 

[Kelvin]

If you want to update the underlying query all you need to do is requery
that box and not the whole form. The form will only requry its data and not
the underlying data for its combo boxes. To requery the combo box use.

Me.NameOfcomboBox.Requery

Kelvin Lu