Linking the common VB checkbox control to Access tables using the ADO data control is not difficult. But I have not been able to find a way to connect the control "programmatically" to a Boolean field in an Access ’97 table. For example… This code won’t load the checkbox control named "Check1(0)" with the value of "NameOfBooleanAccess97Field": Check1(0) = !NameOfBooleanAccess97Field And this code won’t load the Access ’97 field named "NameOfBooleanAccess97Field" with the value of the checkbox I've named "Check1(0)": !NameOfBooleanAccess97Field = Check1(0) This MUST be easy to do. What am I missing? I'm willing to pay for the answer.
Code that will enable me to use ADO to connect a common VB6 checkbox control programmatically to a boolean field in an Access '97 table.
All flavors of Windows '95 thru XP.