Forum home » Delegate support and help forum » Microsoft Access Training and help » Sub-form Update on Change to Main Form
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Sub-form Update on Change to Main Form
Resolved · Low Priority · Version 2007
Reply Mon 13 Dec 2010, 23:31Delegate Jamie said...
Jamie has attended:
Access Intermediate course
Access Advanced course
Sub-form Update on Change to Main Form
Hi,
I have created a sub-form and a form, based on 2 tables:
tblCompanies
tblAccount Codes
All is working fine, except for one particular situation. The Primary Key for tblCompanies is a 3-letter code which the user can assign. If the user changes the code in the main form, the records displayed in the sub-form disappear. If you then advance to the next record on the main form and then return to the original record, the updated code is displayed with the appropriate data in the sub-form.
It seems that the cascade update is working fine, it just doesn't update until the record is saved. Is there a way to force the update immediately so that the 3-letter code is changed, but the sub-form data doesn't disappear?
Thanks,
Jamie
For upcoming training course dates see: Pricing & availability
RE: Sub-form Update on Change to Main Form
Hi Jamie, thanks for your query. You've spotted an irritating drawback about forms! Essentially, you need to get that sub-form to refresh, which is a bit of a lengthy process to post here but this link should explain the nuts and bolts:
http://www.techonthenet.com/access/subforms/refresh.php
Hope this helps,
Anthony
Tue 21 Dec 2010: Automatically marked as resolved.
|