Solved

Case statement

Posted on 2014-09-23
4
187 Views
Last Modified: 2014-09-23
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
0
Comment
Question by:pdvsa
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 12

Expert Comment

by:danishani
ID: 40340395
I am not able to download your DB. When I click on the link it opens a page with bunch of text in it.
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 40340421
open your form in design view and make sure that the

Before update event of the combo have [Event Procedure]
0
 

Author Comment

by:pdvsa
ID: 40340444
Will do so shortly as not at computer now.
0
 

Author Closing Comment

by:pdvsa
ID: 40340486
that was it!  thank you
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question