Forcing on a status, depending on calculation

C.D

Registered User.
Local time
Today, 12:55
Joined
Sep 29, 2007
Messages
42
Hi, I know this is a fairly easy one. I really try to avoid asking answered questions, but I've honsestly searched through the forum with no results..

I have three statuses:
1 = Ongoing
2 = Complete
3 = Dropped

I want to force status 2, if IIf([EPsDL]/[TotalEps]=0;2;""), so that it would force on status 2, only when the calc. gives zero, and thus letting me change status freely, as long as the calc. is >0.
I don't know whether to use IIf, nor where to put it at all. Would it work in a query, and if so - where to put it?

Thanks in advance :)
 
You can perform your test in the Current event of a form that can set the value of your control and enable/disable other controls at your pleasure.
 

Users who are viewing this thread

Back
Top Bottom