setting value of unboud check box

[karen scheu via AccessMonster.com]

I have a form that is bound by a query. The query joins two tables. One
table is not updatable and the other is. One of the on the form is a
shipping indicator (Yes/No Field). The problem is that shipping indicator
is not updatable on the form. How can I accomplish allowing the user to
check this shipping indicator and have the underlying table get updated.

I tried adding an unbound check box to the form, and I update the table on
the after update event of this checkbox, but I can't seem to figure out how
to set the value to -1 or 0 on the form depending on the value in the bound
shipping indicator field. If the value of the shipping indicator in the
table is Yes, then I want the unbound checkbox to be checked. If the value
is No, then I want the unbound checkbox not to be checked. Any suggestions?
I am new to using check boxes, so any better ideas would be appreciated also.

Thanks,

 

[Mark A. Sam]

Hello Karen,

In the end of the code in the unbound checkbox place the expression:

Me.Refresh

If that fails then try

Me.Recalc

Me.Refresh is preferrable, becuase it doesn't cause the screen to flicker.

God Bless,

Mark A. Sam

 

[karen scheu via AccessMonster.com]

Thanks for the respponse, but I don't think that the refresh will help.

I have an bound form to a query. I need a check box on the form that will
both show a check if the value in the table is set to "Y" and also allow the
user to check it or uncheck it. The problem is that if I use a bound
checkbox control on the form, user can not update it. If I use an unbound
control on the form, I don't know how to update the unbound control with a
check or no check depending on the value in the table. The form allows
navigation and so when the rowsource changes, I need to update the unbound
control, but how do I capture the navigation change event?

Thanks

Hello Karen,

In the end of the code in the unbound checkbox place the expression:

Me.Refresh

If that fails then try

Me.Recalc

Me.Refresh is preferrable, becuase it doesn't cause the screen to flicker.

God Bless,

Mark A. Sam

I have a form that is bound by a query. The query joins two tables. One
table is not updatable and the other is. One of the on the form is a

[quoted text clipped - 11 lines]

Thanks,

 

[Mark A. Sam]

Karen,

You can handle assigning the unbound checkbox from the CurrentEvent of the
form like this:

[UnboundCheckBox] = [BoundCheckBox]

You may need to place the bound checkbox on the form and set its Visible
Property to false.

God Bless,

Mark A. Sam

Thanks for the respponse, but I don't think that the refresh will help.

I have an bound form to a query. I need a check box on the form that will
both show a check if the value in the table is set to "Y" and also allow the
user to check it or uncheck it. The problem is that if I use a bound
checkbox control on the form, user can not update it. If I use an unbound
control on the form, I don't know how to update the unbound control with a
check or no check depending on the value in the table. The form allows
navigation and so when the rowsource changes, I need to update the unbound
control, but how do I capture the navigation change event?

Thanks

Hello Karen,

In the end of the code in the unbound checkbox place the expression:

Me.Refresh

If that fails then try

Me.Recalc

Me.Refresh is preferrable, becuase it doesn't cause the screen to flicker.

God Bless,

Mark A. Sam

I have a form that is bound by a query. The query joins two tables. One
table is not updatable and the other is. One of the on the form is a

[quoted text clipped - 11 lines]

Thanks,