Checkbox status from combobox

[justhininabouti]

I have a field (Marital Status), who's data type is an entered lookup table (Married, Single, Widowed, Divorced, Seperated). The user would prefer not change the look of the current (Paper, 3 part, with carbon (remember that stuff) form which uses check boxes for these entries. Most of the time this report will be call for a single individual, however once a year it will be called for a number of people at once. I'd like to just check the checkbox that coresponds to the combobox item selected.

I was thinking of using a VBA Event Procedure attached to the 'On Load' event to accomplish this. Will this work? Is there another method that would be more effecient?

TIA

[NTC]

Use the OnFormat event which is found in the section of the form these unbound checkboxs are located.

Remember to toggle off the check(s) as the start of the code otherwise prior checks will remain in affect. If this isn't clear - you see what I mean as soon as you do a few trials.

Hope it helps.

[justhininabouti]

NTC, Thanks. I tried your suguestion, and I see how it will work, but I'm having a problem. when I use...

Me.rptMarried.value = 0 (or no or false) I get the following message...

Run-time error '2448'
You can't assign a value to this object.

Any Ideas?

[justhininabouti]

I found the problem. I had created the checkboxes inside a frame. I deleted the checkboxes, and recreated them outside the frame, and all is fine.

Thanks again NTC!