Having trouble using check boxes

[pintojm]

Hey guys,
I've hit a brick wall with a form I'm designing but I'm pretty new to access so I'm hopeful for a quick fix. I've designed a form that populates a table with several fields. 5 of the 7 work perfectly; however, the two with check boxes are giving me fits. One is supposed to be a "check only one" while the other's a "check all that apply". Neither populate the desired fields in the table. Do I need to change the data type in the table before they'll auto fill? Or is there something special to do in form design view? I built the form from scratch so I may have neglected to do something.
Thanks,
Pinto

[June7]

A checkbox is designed to save a 0 or -1 value into a Yes/No type field if it is bound to that field. The 'check all that apply' doesn't fit that conventional structure. Closest thing to that would be a multi-value field with a multi-select combo or list box bound to a text field. I NEVER use multi-value fields.

[mrojas]

Can you post a copy of the form? I picture is worth...

[pintojm]

Hopefully this helps.

[June7]

That will require code (I use only VBA).

So in the checkbox Change event procedure:

If Me.checkboxName = True Then
Me!fieldname = "DNA"
Else
Me!fieldname = Null
End If

However, this is not a normalized data structure and I think will cause you issues in future.

[pintojm]

Ok thanks. So do you think I would be better off in the long run by simply using a drop list or combo box or something?

[June7]

Oh wait, I thought you meant each checkbox had an associated field. But if there really are only two fields (not 38) then 2 comboboxes would be simpler. Otherwise, need code to save appropriate value.

[pintojm]

Ok so I have the combo boxes in my form now, but in my test runs they still aren't populating the appropriate fields in the table. The table fields are both currently formatted as "text". Do I need to change this? I want it to work out so that if I select "Option A" in the Branch combo box, Option A shows up in the Branch field on my table.

[June7]

Is the form bound to the table? Did you set the Control Source property of each combobox?

[pintojm]

I have the correct columns in the respective bound column boxes on the property tab but idk what to put for control source. The drop arrow provides every field but the two I need as options.

[June7]

Then those fields are not included in the form RecordSource. Is the RecordSource a reference to table or query or an SQL statement?

If you want to provide db for analysis, follow instructions at bottom of my post.

[pintojm]

Report - Copy.accdb

Thanks again for all your help.

[pintojm]

Annnd I think I just got it. Formatted the box as a Value List and then just typed in what I want and it populated the table.