"Yappy" wrote in message
...
Thanks for your help. I am putting this into a text box called New Cert
Due
on a form. My Certification Frequency is a combo box with the choices of
Annual, Semi-Annual, Quarterly, and Monthly. I want it to calculate the
date
based on the Certification Date and the Frequency chosen.
I tried your expression and it is returning the following: #Name?
So you've gotten past the syntax error? Hmm, a #Name error ... is there a
field in your form's recordsource table named "New Cert Due"? If a control
has the same name as a field, it must be bound to that field, so if "New
Cert Due" is the name of a field, you can't have a calculated control with
that name.
--
Dirk Goldgar, MS Access MVP
Access tips:
www.datagnostics.com/tips.html
(please reply to the newsgroup)