Checkbox in subform

[vince1818]

Hi MS access experts,

I have a continuous subform linked in a data query, I added some check box to select for each record. However, everytime I check a checkbox, it also check the same checkbox on the next record.

My check box consists of Shipping options - FEDEX, COURIER and HAND DELIVERY. These are the options I need to check for each records in the subform.

is there a way I can select different checkbox for each record?

Please advise. Thank you!

 

[pbaldy]

The checkbox needs to be bound to a field in the subform's source.

 

[vince1818]

Hi Paul,

Thanks for your reply. Im not sure how I can add the fields since I am using a query from the linked DB. I cant add new fields unless I create a new table. Any thoughts? Thanks!

 

[pbaldy]

Let's clarify, are these checkboxes inside a frame? If so, it's the frame that needs to be bound, not the checkbox(es). In any case, to keep the data separate for each record, it has to be tied to that record somehow. If the checkbox or frame is unbound, Access doesn't know what record to apply it to so it shows it for all of them.

 

[vince1818]

Is it possible to add new fields in a linked table?

 

[pbaldy]

Typically yes, but it would have to be done in the back end, then refresh the linked table to see them.

 

[vince1818]

Hi Paul,

quick question, unfortunately, I dont have the ability to add fields in the backend because im importing the DB from the application we are using. Is there any other way to create a check box(es) in my subform? Thanks

 

[pbaldy]

If you're trying to save data associated with the back end data, and you can't create fields in the back end (or have them created for you), perhaps an option is creating a table in your db that relates to the existing back end. It would have the primary key of the existing back end, plus your extra field(s). Presumably it would be in a separate split back end.