By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,451 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

Should I repaint subform or mainform?

P: n/a
MLH
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.
Jan 12 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

"MLH" <CR**@NorthState.net> wrote in message
news:uf********************************@4ax.com...
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.


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
Jan 13 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.