Solved

Case statement

Posted on 2014-09-23
4
183 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
  • 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to execute an access 2007 module from vb6 2 35
Best way to create dynamic, short cut menu 7 27
Programmer 14 48
ACCESS 2010 - VBA - generic Table Open Button - Code 7 24
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

773 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