pdvsa
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
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Will do so shortly as not at computer now.
ASKER
that was it! thank you