Checkbox Question

[markod]

Hello,

I have a form that uses two tables (TABLE_SN and TABLE_DETAIL). TABLE_SN is used to provide a list of serial numbers in a combo box. TABLE_DETAIL is used to record customer information.

Basically I would like to have a checkbox on the form that updates a field “AVAIL” on the “TABLE_SN” table. This checkbox should always reflect the value of this field. In other words, when a new record is created if the “AVAIL” field is populated with”Yes” then the checkmark will be checked by default.

This may be really easy to do but I haven’t had any luck.

Thanks

[ConneXionLost]

View [TABLE_SN] in Table Design mode, and select the [AVAIL] field.

Since you want to connect this field to a checkbox, you should probably use the "Yes/No" Data Type.

On the General tab, set the Default Value for the [AVAIL] field to "Yes" (but don't use the quotes).

Add the checkbox to your form (in form design view) for [TABLE_SN] and set the Control Source to the [AVAIL] field.

Cheers,

[markod]

Thanks for your quick response. Forgive my rookieness but it seems only the fields in the "TABLE_DETAIL" table are available in the Control Source drop down. Is there a way to reference the TABLE_SN fields? I've tried typing in TABLE_SN.AVAIL but this is invalid.

[ConneXionLost]

I was wondering about that. I had assumed, when you stated:

I have a form that uses two tables (TABLE_SN and TABLE_DETAIL).

that you were referring to a form/subform arrangement. I guess that isn't the case.

What is the relationship between [TABLE_SN] and [TABLE_DETAIL]? How are they joined? What fields do they have in common?

[markod]

Poking around I ended up going with a subform to edit the fields. Thanks for replying and your assistance.