Refer to parent form on sub form

[schum1]

I have a textbox (LastUpdate) on a parent form (ProjectID) that must be automatically updated with the latest date when information on a subform (ProjectStaffRoles) has been changed. The database (adp) was created in Access 2000 and the following BeforeUpdate code works perfectly in Access 2000 [Forms]![projectid]![LastUpdate] = Now()

My problem is that one of our users works on Access 2002, and get the following error message when trying to save a record in the subform:
Run-time error '-2147417848 (80010108)': Method 'Value' of object' _AccessField' failed. The changes are then discarded. I tried some other suggestions that can be found at

http://users.bigpond.net.au/abrowne1/casu-04.html.

But nothing worked thus far.

Any help would be greatly appreciated.
Thank you

 

[KenReay]

Hi

Have you tried Parent.[LastUpdate] = Now() ?


Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[schum1]

Hi Ken

Thank you for your quick reply and suggestion. I tried it out, but it did not work. In the end I solved the problem by using Forms.ProjectID.LastUpdate = Now(), which seems to work fine with both Access 2000 and Access 2002.

I appreciate your help though.