Hi. I have a form (frmmasterform

[cbsquared2000]

Hi.

I have a form (frmmasterform) that has a sub form (frmerror) and works as a 0ne to Many Relationship. On my master form, I have a field that is text that simply indicates whether the record has a related error in the subform. Right now the field is manually entered, but I would like to auto populated it based on the error form. For example, if there is an error (is not null) then populate the master field with yes, else if there is no error (is null) then populate it with no. I can do this when the fields are on the same form with an IIF statement, however, how do you link it to another form?

Thanks

 

[AccessAce]

I think this is the right syntax for you
Forms!Formname.field=True

Does this help?

 

[cbsquared2000]

Sorry for being so ignorant, but where does that syntax go?

Thanks