Z
zat via AccessMonster.com
Reading through the postings I realize, to update a table, the control source
in a form has to have the field's name. I have two fields in my form (Org &
Poc) and when a user selects from the Org field the Poc auto populates. I've
accomplished this with =[org].column(2) in the Control Source of POC, which
does not post the Poc entries to the table. The other issue contains three
fields: Reply, Num and Status. If Reply is checked Status=Open. If Reply is
not checked Status=Not Required. If Reply is check and Num has a value, then
Status=Closed. I've accomplished this by putting =IIf([ysnReplyFlag]=No,"Not
Required ",IIf([ysnReplyFlag]=Yes And [strCrossRef] Is Null,"Open","Closed"))
in the Control Source of the Status field. So since this isn't updating my
tables, what is the correct way of accomplishing these tasks? Thanks so much!
in a form has to have the field's name. I have two fields in my form (Org &
Poc) and when a user selects from the Org field the Poc auto populates. I've
accomplished this with =[org].column(2) in the Control Source of POC, which
does not post the Poc entries to the table. The other issue contains three
fields: Reply, Num and Status. If Reply is checked Status=Open. If Reply is
not checked Status=Not Required. If Reply is check and Num has a value, then
Status=Closed. I've accomplished this by putting =IIf([ysnReplyFlag]=No,"Not
Required ",IIf([ysnReplyFlag]=Yes And [strCrossRef] Is Null,"Open","Closed"))
in the Control Source of the Status field. So since this isn't updating my
tables, what is the correct way of accomplishing these tasks? Thanks so much!