Delete specific fields on cbo change

[Stockwell43]

Hello,

I was wondering if someone can help me with an issue.

I have a database that has a CBO called "Balance Change". When the user
clicks the CBO to change the status to read "Closed", I would like for the
"Effective Date Addition" and "Begin Date" fields to be blank or deleted on
that record. Because once they change the CBO to close, that record will no
longer be needed.

Thanks!!

 

[Jeff Boyce]

I suspect you could add code on that combobox's AfterUpdate event that
"empties" your other controls. It might look something like:

Me!txtEffectiveDateAddition = Null
Me!txtBeginDate = Null

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Stockwell43]

Hi Jeff,

Thank you for your reply. Your code works like a gem! Only thing is there
are three choices in the CBO and I only want the two date field to delete
when they select "Closed" from the CBO. Is that possible?

Thanks!!

 

[Stockwell43]

Hi Jeff,

I figured it out. I took what you gave me and wrote an If....Then statement
and it works great.

Thank you for your help!!