473,378 Members | 1,133 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

Should I repaint subform or mainform?

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
1 4852

"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Sabine Oebbecke | last post by:
Hi Experts! I have several forms and reports where controls get their values with 'Forms!MainForm!Control' or 'Forms!MainForm!Subform!Control' resp 'Forms!MainForm!Subform.Form!Control' which...
0
by: P Mitchell | last post by:
Hello I would like someone to be able to help with the updating of data in a lookup list in a subform. In short, is their a VB instruction that is the equivalent of performing the action of...
1
by: phaddock4 | last post by:
Being fairly inexperienced at Access 2000, i've been reading many posts here for the last several days, and testing myself to find the best approach to do the following in A2K: SET UP: I have...
5
by: ego | last post by:
Hi all , I had created the following Form/SubForm structure : MainForm SubForm A (SubForm of MainForm) SubForm B (SubForm of SubForm A) SubForm C (SubForm of SubForm B) SubForm D ...
1
by: ken | last post by:
Hi, I have a MainForm and a SubForm. I also have a popup form that is opened by a button click on the subform. On that form I want to set the main form and subform. to set mainform you do this:...
4
by: ken | last post by:
Hi, I have a MainForm and a SubForm. I also have a popup form that is opened by a button click on the subform. On that form I want to set the main form and subform. to set mainform you do this:...
2
by: John | last post by:
I have a mainform with a subform. The subform is sorted on a specific field and when I just open the subform, the sorting is OK. However, when I open the mainform, the sorting in the subform is...
18
by: Robert Jacobs | last post by:
Please advise... I currently have a Mainform (Customers) and a Subform (Service Requests) with a one to many relationship (one customer, many service requests) with a CustomerID that is unique...
24
by: bkberg05 | last post by:
Hi - I have a form called mainForm that has a subform called subForm. The subform has a numeric field called subCost. There are many subForm records for every mainForm record. On the main form,...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.