Link to home
Start Free TrialLog in
Avatar of pdvsa
pdvsaFlag for United States of America

asked on

Case statement

experts,

I have had some corruption and not sure why the form's CASE code is no longer working.
I have some criteria on a users input into a combo box and date field.

Here is a part of the Case statement criteria:
If JBIC  then :  date to receive funds must be >30 days from Date of Request form
all others the date to receive funds must be >5 days but not >25 days from Date of Request form (basically 5<>25)

Please see attached db.  It is pared down and the form opens automatically.  

I have been fiddling around with this for too long and cant even seem to get any msg box text to appear.  I dont know if its because there was some corruption.  

thank you
EE.accdb
Avatar of danishani
danishani
Flag of United States of America image

I am not able to download your DB. When I click on the link it opens a page with bunch of text in it.
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of pdvsa

ASKER

Will do so shortly as not at computer now.
Avatar of pdvsa

ASKER

that was it!  thank you