Should I repaint subform or mainform?

[MLH]

I have frmVehicleEntry Form and on it is frmAddnlOwnrLis tSubForm.
The subform is unbound and lists records in a table, allowing the
user to change values in CheckMark controls on the subform as
desired.

I have another button that will allow user to run a query which will
update the field values related to the checkmark control to False.
To be sure the changed values show up in the subform control, I'm
thinking of running a line like the following:

DoCmd.RepaintOb ject acForm, "frmVehicleEntr yForm"

I don't know if the form argument should be the main form or the
subform. Just thought I'd ask you guys.

[Jeff Smith]

"MLH" <CR**@NorthStat e.net> wrote in message
news:uf******** *************** *********@4ax.c om...

I have frmVehicleEntry Form and on it is frmAddnlOwnrLis tSubForm.
The subform is unbound and lists records in a table, allowing the
user to change values in CheckMark controls on the subform as
desired.

I have another button that will allow user to run a query which will
update the field values related to the checkmark control to False.
To be sure the changed values show up in the subform control, I'm
thinking of running a line like the following:

DoCmd.RepaintOb ject acForm, "frmVehicleEntr yForm"

I don't know if the form argument should be the main form or the
subform. Just thought I'd ask you guys.

From the HELP FILE on the RepaintObject Action:

Notes
This action doesn't cause a requery of the database, so it doesn't show new
and changed records or remove deleted records from the object's underfying
table or query. Use the Requery action to requery the source of the object
or one of its controls. Use the ShowAllRecords action to display the most
recent records and remove any aplied filters.

The RepaintObject action doesn't have the same effect as choosing the
Refresh command from the Records menu, which shows any changes you or other
uses have made to the currently displayed records in forms and datasheets.
Jeff