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
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