Check box using iif statement

jedder18

Just Livin the Dream!
Local time
Today, 13:20
Joined
Mar 28, 2012
Messages
135
Access 2007
Win 2007

=IIf([max%]>0.7,Yes,No)


expression to populate a check box on a subform

When I use this and run...the yes works correctly
the No wipes out the records' other data(i.e. staffid, name of training) from the query max% is running in.

How do I keep this showing and have the checkbox unchecked?

TIA.

Jennifer
 
Can you show how it clears the other data?
 
Sorry Dear llkhoutx, I wanted to know from Jedder18 about how other fields wipes out with example to understand the problem.

the No wipes out the records' other data(i.e. staffid, name of training) from the query max% is running in.
 
Operator error folks...
sorry, I figured it out...
had other criteria setup in query that needed to be deleted.
 

Users who are viewing this thread

Back
Top Bottom