Checkbox to store into Table Field

[sud2017]

I have a checkbox (ChkWest) and a bound Textbox field 'TxtAssyQty' (controlsource is from a Table). When user checks the checkbox 'chkWest', I want to store the TxtAssyQty =1, to be stored in that table.

I understood how to update ChkWest value to an unbound Textbox but I am not sure how to store into the table.

Would greatly appreciate for any possible help.



Thanks very much.

[pbaldy]

I'm not sure I understand. Updating a bound textbox would be the same as updating an unbound textbox.

[sud2017]

Sorry for not being very clear. To update the Unbound textbox value based on checkbox selection, I previously have used IIF statement in the Controlsource of that textbox (IIF(ChkWest = True, "1", "0"). However, by doing this, the textbox doesn't store the value to the table as the textbox becomes unbound. I hope I haven't confused you more. Is there a different way to store value to the table field based on checkbox selection? Thanks for any possible help.

[Bulzie]

I think Paul saying why not just bind the check box on the form to the field in the table?

[pbaldy]

In the after update event of the checkbox try:

Me.TextboxName = IIF(ChkWest = True, 1, 0)

[sud2017]

Thank you very much Paul and Bulzie. Great suggestions. I have bound check box on the form directly to the field in the table but when its checked it stores value "-1", when unchecked it works fine with "0". Please advise. Thank you again.

[Bulzie]

Thats just how it stores it in the table, -1 = True, 0 = False.

[sud2017]

Thanks again for your quick reply Bulzie. I want the stored value to be "1" instead of -1 when the checkbox = true, as I intend to use this stored value for a calculation in my form. Would appreciate your further advise to achieve this or if there is anything wrong with my approach. Your time is much appreciated.

[pbaldy]

Did you miss post 5?

[sud2017]

Did you miss post 5?

Paul - this worked so great. sorry I had missed that post. You are awesome. I was struggling with this for last 2 days.

Thank you and have a great day to both of you.

[pbaldy]

No problem. Sometimes answers get lost in the clutter.