Should I repaint subform or mainform?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MLH - 12 Jan 2006 17:00 GMT

I have frmVehicleEntryForm and on it is frmAddnlOwnrListSubForm.
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.RepaintObject acForm, "frmVehicleEntryForm"

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

Reply to this Message

Jeff Smith - 13 Jan 2006 08:32 GMT

>I have frmVehicleEntryForm and on it is frmAddnlOwnrListSubForm.
> The subform is unbound and lists records in a table, allowing the
[quoted text clipped - 10 lines]
> 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

Reply to this Message