Creating a "shopping cart" like function

[jbaccess]

I'm new to Access and wanting to create a shopping cart like function of inventory items that an end user can then pre-screen and check off the actual items to go forward to a new form/query to be assigned a bid control number and then be exported to excel for further processing internally.

I have the form designed, and the checkbox is bound to the inventory items, however, I cannot seem to be able to activate the checkbox control. I can check the boxes, but it's either none of them or all of them. I've tried On Got Focus, After Update, and many others, but hitting roadblock on all fronts.

I have the command button set to requery when the checkboxes are clicked.

Here's what I have so far:

Private Check15()
If Me!Check15.Value = True Then
Me!Command17.Enabled = True
Else
Me!Comand17.Enabled = False
End If
End Sub

Thanks for your quick response.

 

[missinglinq]

...the checkbox is bound to the inventory items

... I can check the boxes, but it's either none of them or all of them.

These two statements appear to contradict each other! You say that the Checkbox is Bound to an inventory Item, presumably in the underlying Table or Query, but the fact that a given Checkbox, in all Records are they same, whether you tick or untick it, indicates that the Checkbox is Not Bound! This is the normal display behavior for Unbound Controls.

Linq ;0)>

 

[jbaccess]

I thought it was bound ... under Data > control source.

How can I get it bound? I obviously have missed something very basic - yet no matter what I do it remains unsolved. I can't find an answer elsewhere, thanks.