Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

MS Access : how to update subform

Posted on 2004-08-21
4
Medium Priority
?
850 Views
Last Modified: 2006-11-17
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
Comment
Question by:Thomas_VDB
[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
  • 2
  • 2
4 Comments
 
LVL 4

Accepted Solution

by:
naivad earned 60 total points
ID: 11859475
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
 

Author Comment

by:Thomas_VDB
ID: 11863224
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
 
LVL 4

Expert Comment

by:naivad
ID: 11864405
Is it a bound or unbound control?
0
 

Author Comment

by:Thomas_VDB
ID: 11867884
the customer contact ID is a bound control.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

609 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