Hi John,
Requery should do it but I've seen people have the Link Master Field be a
calculated unbound control on the main Form so the control needed to be
recalculated first, example:
Me.Repaint ' repaints ALL calculated controls on Form
Me.BidInfo.Form.Requery
Me.BidInfoDetail.Form.Requery
Me.SpecDefaults.Form.Requery
Me.GCJobDetail.Form.Requery
In scenarios like this the subForm controls are dependent on the calculated
Link Master Field control that was not repainted (or refreshed). Try the
above to see if it helps.
Eric
--------------------
| Content-Class: urn:content-classes:message
| From: "John" <
[email protected]>
| Sender: "John" <
[email protected]>
| References: <
[email protected]>
<mbFIH#
[email protected]>
| Subject: RE: Refreshing forms when making a change to values
| Date: Thu, 4 Mar 2004 06:58:45 -0800
| Lines: 98
| Message-ID: <
[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcQB+TFbUY1DuEjpQX2gGtQ6bwBy+g==
| Newsgroups: microsoft.public.access.formscoding
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.formscoding:223315
| NNTP-Posting-Host: tk2msftngxa08.phx.gbl 10.40.1.160
| X-Tomcat-NG: microsoft.public.access.formscoding
|
| For some reason the forms are still not refreshing. Could
| it be that I need to refresh the default values table. I
| have to close out of the form and go back in for the
| information to be right.
|
| Thanks,
| John
|
|
|
| >-----Original Message-----
| >Hi John,
| >
| >Try:
| >
| >Form_Main.BidInfo.Form.Requery
| >Form_Main.BidInfoDetail.Form.Requery
| >Form_Main.SpecDefaults.Form.Requery
| >Form_Main.GCJobDetail.Form.Requery
| >
| >I hope this helps! If you have additional questions on
| this topic, please
| >respond back to this posting.
| >
| >Regards,
| >
| >Eric Butts
| >Microsoft Access Support
| >
| >"Microsoft Security Announcement: Have you installed the
| patch for
| >Microsoft Security Bulletin MS03-026? If not Microsoft
| strongly advises
| >you to review the information at the following link
| regarding Microsoft
| >Security Bulletin MS03-026
| ><
http://www.microsoft.com/security/security_bulletins/ms03
| -026.asp> and/or
| >to visit Windows Update at
| <
http://windowsupdate.microsoft.com/> to install
| >the patch. Running the SCAN program from the Windows
| Update site will help
| >to insure you are current with all security patches, not
| just MS03-026."
| >
| >
| >
| >--------------------
| >| Content-Class: urn:content-classes:message
| >| From: "John" <
[email protected]>
| >| Sender: "John" <
[email protected]>
| >| Subject: Refreshing forms when making a change to values
| >| Date: Wed, 3 Mar 2004 14:35:45 -0800
| >| Lines: 20
| >| Message-ID: <
[email protected]>
| >| MIME-Version: 1.0
| >| Content-Type: text/plain;
| >| charset="iso-8859-1"
| >| Content-Transfer-Encoding: 7bit
| >| X-Newsreader: Microsoft CDO for Windows 2000
| >| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| >| Thread-Index: AcQBb936AsAkGYC9RJu+o5F6yjWTTQ==
| >| Newsgroups: microsoft.public.access.formscoding
| >| Path: cpmsftngxa06.phx.gbl
| >| Xref: cpmsftngxa06.phx.gbl
| microsoft.public.access.formscoding:223224
| >| NNTP-Posting-Host: tk2msftngxa13.phx.gbl 10.40.1.165
| >| X-Tomcat-NG: microsoft.public.access.formscoding
| >|
| >| I have a main form that has a three subform within it.
| >| When a user clicks on a button, I run a procedure that
| >| changes data in a default values table. These values
| are
| >| in the where clauses of all the subform's record
| sources.
| >| I use the requery method in code to try to refresh the
| >| subforms to show the data that was inserted in the
| default
| >| values table, but it does not seem to refresh the form
| >| with that data. Default values only has one record in
| it.
| >| Below is the requery code I use. If someone knows what
| I
| >| am doing wrong and the code I actually need I would
| >| greatly appreciate it.
| >|
| >| Form_Main.BidInfo.Requery
| >| Form_Main.BidInfoDetail.Requery
| >| Form_Main.SpecDefaults.Requery
| >| Form_Main.GCJobDetail.Requery
| >|
| >|
| >| Thanks,
| >| John
| >|
| >
| >.
| >
|
