=> Check Box source int column shows tick for all >0

  • Thread starter Thread starter Rhonda Fischer
  • Start date Start date
R

Rhonda Fischer

Hello,

I have a check box on a form. The recordsource of
this check box is an integer column. The numbers
that are saved to this integer column are from a
collecton of option buttons contained in an option group.

The problem I am having is that I would like the check
box to remain unticked where the table column is 0 or
1 and I would like the check box to be ticked where
Click to expand...
the value of the source column is 1.

How can I do this?

Your suggestions would be most appreciated.

Thank you kindly
Rhonda


---------------------------------------------------------
For example:

Tble: Trailer Movements
Integer saved in Table When option button Selected
0 No Option buttons
1 Trailer is Empty upon return
2 Trailer was for Frozen goods
3 Trailer was for Chilled good
----------------------------------------------------------
 
Rhonda,

Add another text box on your form (called, say, "Status"), bound to the
table field, and set its visible property to No (you won't display it on the
form). Now, in the checkbox properties, set the control source to:
=Iif([Status] = 1, True, False)

This should do the job.

HTH,
Nikos
 
Dear Nikos,

Thank you very much. Perfect. It works :)

Cheerio
Rhonda
-----Original Message-----
Rhonda,

Add another text box on your form (called, say, "Status"), bound to the
table field, and set its visible property to No (you won't display it on the
form). Now, in the checkbox properties, set the control source to:
=Iif([Status] = 1, True, False)

This should do the job.

HTH,
Nikos

Hello,

I have a check box on a form. The recordsource of
this check box is an integer column. The numbers
that are saved to this integer column are from a
collecton of option buttons contained in an option group.

The problem I am having is that I would like the check
box to remain unticked where the table column is 0 or
the value of the source column is 1.

How can I do this?

Your suggestions would be most appreciated.

Thank you kindly
Rhonda


-------------------------------------------------------- -
For example:

Tble: Trailer Movements
Integer saved in Table When option button Selected
0 No Option buttons
1 Trailer is Empty upon return
2 Trailer was for Frozen goods
3 Trailer was for Chilled good
--------------------------------------------------------
Click to expand...
--


.
Click to expand...
 
Back
Top