Populate checkbox

[Ashe]

I have a form with several text boxes and one check box. Three texts boxes are used for data entry and the other text box and the checkbox are parent data that are called up for reference’s sake. The text is called up from a Select command in the row source, and I thought I could call up the correct value of the check box by putting a select command in the control source, but it’s not working. I have “Select Table.Checkbox FROM Table” in the control source, but it doesn’t populate the check boxes according the selected text (it doesn’t populate them at all). What am I missing?


Thank you in advance!
PS: While I am working in Access 2010, this database is an .mdb and must be operable in A2003.

[RuralGuy]

The CheckBox would need to have a ControlSource of one of the fields in the RecordSource of the form.

[Ashe]

Bummer! There's no way around that?

Could I add something to the RecordSource table that would automatically pull the data from the Checkbox table? Or maybe some fancy subform work?

[RuralGuy]

A form is allowed one RecordSource, period! That can be a query that involves a number of tables, but it all must be in one RecordSource. You can use Domain Functions to retrieve values from other non related tables if you want (DLoopup(), DCount(), etc). I would put the Domain Functions in the Current Event of the form.

[Ashe]

Can a domain function be entered directly into the control source?

[RuralGuy]

Generally the answer is yes.

[RuralGuy]

What is wrong with putting them in the CurrentEvent of the form?

[Ashe]

It's a continuous form, so I'm concerned that the CurrentEvent wouldn't work when the user goes to enter a second record...

[RuralGuy]

As you know, continuous views are really just one view repeated. They do not always do as you want when the controls are not bound to the RecordSource.

[Ashe]

Yes, they're certainly tricky!
Thanks for your help!