?
Solved

Subforms will not refresh

Posted on 2013-05-29
6
Medium Priority
?
273 Views
Last Modified: 2013-05-29
I have all but got part of a database written, but I am stumped on a little issue.

In the attached sample database (all the data is made up), the frmEditGroup will not refresh the subforms containing the contact details.

There is another form (frmNewGroup) on which the Edit form is based, that works fine.

I cannot see what is wrong.  The code on the After_Update event on the combo boxes looks fine (and works on the “NewGroup” form)

Hope someone can help me here.

Regards
Richard
Test-database.mdb
0
Comment
Question by:rltomalin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 39204465
try adding the field "GroupID"  to the record source of the subform  containing the contact details.
0
 

Author Comment

by:rltomalin
ID: 39204543
Hi capricorn1
Thanks for the feedback.  That doesn't seem to make any difference.
Adding the GroupID into the subform query doesn't make any difference to the fact that the NewGroup form works fine (and it uses the same subform and code.

Any other suggestions?

Regards

Richard
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 39204557
tell me, how it is not working?
0
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 

Author Comment

by:rltomalin
ID: 39204586
Hi capricorn1

On the frmEditGroup form - selecting a different Contact in the combo box does not refresh the contact details shown in the subform.
In the frmNewGroup form this works fine (but to show this you need to create the new contacts of course.

Hope that is clear.

Regards

Richard
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 39204656
use these codes

Private Sub cboMainContactID_AfterUpdate()
Me.Dirty = False
    Me.MainContactDetails.Form.Requery ' update the subform
       
End Sub
0
 

Author Closing Comment

by:rltomalin
ID: 39204712
Excellent - just got it sorted before I go on holiday!!

Thanks very much capricorn1

Best regards

Richard
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question