Sub-form Update on Change to Main Form

Resolved · Low Priority · Version 2007

Mon 13 Dec 2010, 23:31 Delegate 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

Wed 15 Dec 2010, 15:49 Trainer Anthony said...

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.

Access tip:

Display current date & time in column of any width

The worksheet function =NOW() returns the current date & time. When entered into a column which is not wide enough to display the value NOW returns, the cell displays ###

View all Access hints and tips

Sub-form Update on Change to Main Form

Sub-form Update on Change to Main Form

RE: Sub-form Update on Change to Main Form

Access articles

Access tip:

Display current date & time in column of any width