Form/Sub form update query?

[GUIDO22]

I have a form displaying individual contract information. This form is a continuous form and on each record I have a button that activates a dialog box with two text boxes to facilitate NOTES entry for the current record on the main form. When I close the dialog form - I need the NOTES text entered to be updated in the corresponding text fields on the continuous form.

I have tried the following :

1. After the dialog has closed - set the main forms Bookmark property/ Requery the form and then reset the forms Bookmark.
Problem with this solution is that occasionally I get ' Not a valid bookmark' error message.

2. In the Unload event of the dialog - I have tried Requery calls for each of the text field controls on the constinuous form prior to the dialog closing. This works fine for records that already exist in the table and the data does reflect the changes correctly. For brand new records, the updates are not reflected on the main form and the data only appears when the main (continuous) form is closed and re-opened.

Does anyone have any ideas on how to do this properly? Has someone done something similar?

Thanks
Regards
GUIDO

 

[edtab]

In the "on close" event of the dialogue form, try
this code:

Docmd.RunCommand accmdSaveRecord

See whether that makes a difference.