Form Link CheckBox to Record

[shank]

Attached is a sample MDB. I want to use the form frmShipThese to select records via checkboxes. I now have them defaulted to being checked. They should default to being unchecked. My issue is getting them linked to each record, as opposed to all records, as it is now. I want to selectively check boxes, then click the button to update those records in the underlying table.



I've googled, but not finding anything that makes sense to me. And I'm sure the problem is me. Can anyone shove me in the right direction?

Thanks!

[Gicu]

To do what you what you need to bind the checkbox to the ShipThese yes\no field in the source table. An unbound control in a continuous form will behave like you have it now (show the same value for all records). And you will not be able to have the form editable if you are using a totals query as you have it now. So get rid of the totals (group by) and make the control source of the checkbox="ShipThese" and it should work as expected.

Cheers,

[pbaldy]

In order for the checkbox to be linked to the record, its control source would need to be set to a field in the table. Note in a multi-user environment this could cause conflicts.

[mike60smart]

Hi Shank

Do you want to filter the records to only show a specific "MustShipFrom" and a specific "Sku", then select the records to be sent?

[shank]

To do what you what you need to bind the checkbox to the ShipThese yes\no field in the source table. An unbound control in a continuous form will behave like you have it now (show the same value for all records). And you will not be able to have the form editable if you are using a totals query as you have it now. So get rid of the totals (group by) and make the control source of the checkbox="ShipThese" and it should work as expected.

Cheers,

Elaborating on what I'm trying to do, I'm using a group query in the form so that I can select, for example, ALL of Sku1 going to GA. If I tied the checkbox and form straight to the table, I'd have to click 19 checkboxes (19 records), correct? With the grouping, I can click 1 checkbox and update all 19 records in the table. What am I missing? Luckily, there will only be one user in the DB at a time.

Thanks!

[shank]

Hi Shank

Do you want to filter the records to only show a specific "MustShipFrom" and a specific "Sku", then select the records to be sent?

Yes. Correct. Sku1 going to GA, I would click 1 checkbox and update the underlying table.

Thanks!

[Gicu]

Unfortunately you cannot do it like that with grouping without using some VBA code as the source becomes not updatable.

Cheers,

[Gicu]

Please have a look at this alternate design.

Cheers,

[shank]

Please have a look at this alternate design.

Cheers,

Excellent! I was just watching a YouTube that was describing a similar way of doing this. This helps a whole bunch!

Thank you!

[shank]

Please have a look at this alternate design.

Cheers,

Addendum: See attached screenshot. How can I get rid of the blank space in the detail section? It's a waste of screen. I select can grow and can shrink as Yes, but no change.

Thanks!

[mike60smart]

Hi

In the attached I changed your Form to a Split Form.

Added a Filter in an Unbound Control in the Header of the Form.

Added the following Code provided by Ling from this https://www.accessforums.net/showthread.php?t=53200

Now you can search for WV then for SKU1 - Click the Command Button and all required Checkbox's will update

[mike60smart]

Hi

Here with Vlad's version modified

[shank]

Hi

Here with Vlad's version modified

Thank you very much!

[shank]

Hi

Here with Vlad's version modified

Here again. Oy! Saying I'm a novice to VB would be an understatement. I took your db and starting changing things to suit my needs. I added another hidden text box. Changed names as well, making it make sense for me. The update must be per 3 fields: [NoSkus], [MustShipFrom], [Sku]. I changed the statement in VB and now getting the attached error. The[NoSkus] field is an integer field. I don't know if the statement needs to be changed for integer vs string. I removed some quotes, no difference. Can you take a peek and tell me what I'm doing wrong?

Thanks again!

[Gicu]

Try this version please.

Cheers,