• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 856
  • Last Modified:

MS Access : how to update subform

Hi,

I have a main form "Customer company", that has a subform "Customer Contact"
In the main form, there is a txtbox that is called "Customer Contact ID".
Depending on this txtbox, the correct record is shown in the "Customer Contact" Subform.

The link is working correctly (I've used the wizard to create the link).

but is only working correctly when I change records in the main form,
not when I manually change the value of Customer Contact ID.

adding a requery of the subform when the Customer Contact ID txtbox changes, doesn't help.

Help !
0
Thomas_VDB
Asked:
Thomas_VDB
  • 2
  • 2
1 Solution
 
naivadCommented:
in design view of the form, go to the properties of the Customer Contact ID text box / combo box. Add an Event Procedure to After Update for that control...

Put this code in the sub

me![Customer Contact]!Form.Requery
0
 
Thomas_VDBAuthor Commented:
I just tried that. Didn't help.

The costomer contact ID text box in the subform doesn't change when I change the one in the main form.

What is going wrong?

As I said, the subform does update when i change record in the main form.
0
 
naivadCommented:
Is it a bound or unbound control?
0
 
Thomas_VDBAuthor Commented:
the customer contact ID is a bound control.
0

Featured Post

Industry Leaders: 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!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now