Check box using iif statement (1 Viewer)

J

jedder18

Just Livin the Dream!

Local time

Today, 00:40

Joined

Mar 28, 2012

Messages

135

• Dec 6, 2012

• #1

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

 

L

llkhoutx

Registered User.

Local time

Today, 02:40

Joined

Feb 26, 2001

Messages

4,018

• Dec 10, 2012

• #2

Try using "True,False," instead of "Yes, No."

 

M

mahenkj2

Registered User.

Local time

Today, 13:10

Joined

Apr 20, 2012

Messages

459

• Dec 11, 2012

• #3

Can you show how it clears the other data?

 

L

llkhoutx

Registered User.

Local time

Today, 02:40

Joined

Feb 26, 2001

Messages

4,018

• Dec 11, 2012

• #4

I don't understand your most recent question.

 

M

mahenkj2

Registered User.

Local time

Today, 13:10

Joined

Apr 20, 2012

Messages

459

• Dec 11, 2012

• #5

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.

Click to expand...

 

J

jedder18

Just Livin the Dream!

Local time

Today, 00:40

Joined

Mar 28, 2012

Messages

135

• Dec 11, 2012

• #6

Operator error folks...
sorry, I figured it out...
had other criteria setup in query that needed to be deleted.