Search results

Thank you for the help. It worked perfectly.

Thanks for the reply. A user can be assigned to multiple projects at the same time, so I don't see how an "Assigned" flag will be of use.

I couldn't find a solution to this in earlier posts, so I'll try to explain my problem here. Here goes... I have a form based on a table of Projects. It has a subform based on a group of Users who are working on each Project. This subform is based on entries in a table called UserProjects...

Thanks for the help Pat. It should have been BeforeUpdate - I don't know why I wrote AfterUpdate. My code is in the BeforeUpdate event. I never even thought about why I was checking the Dirty property. The example code I used from Microsoft had the Dirty check in it and I just copied it...

I am having trouble checking the "Dirty" property in a subform. The AfterUpdate event fires and I have verified that the value of the field has changed. I tried using "Me.Dirty" and Forms![frmMasterAccounts]![frmSubAccounts].Form.Dirty, but they both return "False". Any other suggestions?