checkbox question

[viper]

Not a real good user of Access but am trying to. I've added a checkbox to a form and report. I only need to check the box if the company has been mailed to. When I check the box on the first entry, I get a check for all other entries when I don't need them.

I've also added the checkbox to my report and need it to be checked if the box was checked on the form for that entry, right now I'm only get a colored in checkbox.

Any help will be greatly appreciated.

Thank you,

 

[Andrew Fergus]

Hi

This usually happens (on the form) when the check box is not assigned to a field. If you go into the form design, right click the check box -> Properties -> Data tab -> Control Source -> set this to the name of the field (using the drop down box) from the underlying table or query. If you don't see the field you want to use in the drop down list, then it first needs to be added to the underlying table and / or query. Repeat for the report.

HTH, Andrew

 

[viper]

Thanks,

I'm not sure what I did but I got it working using a textbox with yes/no.