access 2007 vba checkboxes

androm31 · September 8th, 2011, 11:40 AM

I would like some help adding a check box to and 'ADO' record set.

I am modifying a case study in chapter 13 of Access 2007 VBA by Denise Gosnell

Unfortunately there isn't one checkbox used throughout the entire book - however its still very good and has got me from zero confidence in coding to being just about able to manipulate many things.

The fields on the existing form lead to object variables that appear about 9 times throughout the code of the application, populating form record sets, sub procedures to clear the forms etc.

I have added a field to the table, added

Code:

Dim blMemberVal as boolean

to a list where other field variables are declared
added

Code:

Public Property Get Member() As Boolean
     On Error Resume Next
     Member = blMemberVal
 End Property
     
 Public Property Let Member(ByVal Value As String)
     On Error Resume Next
     blMemberVal = Value
 End Property

Oh, I have just seen what I have done!
I was getting onload parameter errors.

Now I have changed (ByVal Value As String) to Boolean it i can get the form to open without error.

However the form will display what is in the database correctly but when I click 'save' which calls an update sql function I am getting an error:
(missing operator) in query expression "0' chkMember = 'False"

Be grateful If someone can assist in checking the code I am using to help resolve this...

Thanks
androm31

added