customize Data values for Check Box

  • Thread starter Thread starter FA
  • Start date Start date
F

FA

Hi Everybody,
I have a form lets say frmForm1 and that form has 10 check boxes. User
can select one or many. The data values in these check boxes are 0 for
unchecked and -1 for checked. My data is on SQL Server and the data is
coming from a webpage. On webpage there is a form that hase the same
check boxes but the webpage check boxes produces data value like
"qr02a, qr02b, and so on..." i want to be able to have the same data
value in my check boxes in MS Access form if they are checked. The
webpage does not give me any value for check box if it is not checked,
but i want to pass a default value if my check box in form is not
checked, lets say "qr02" I tried many things but its not working for me
Again let me rephrase my problem.
I want to have data value in my check boxes like "qr02a" for checked
and qr02 for unchecked instead of -1 for checked and 0 for unchecked.

If someone help me out with any VBA Code for this, i would really
appreciate it.
 
I forgot to mention, each check box should be bound to a field in
table. For instance Check1 --- ControlSource DA_SOX
Check2 ---- ControlSource DA_NPI
and so on...
DA_SOX and DA_NPI takes the data directly from webpage and they are
Varchar fields and take "qr02a, qr02b,,," if the user checked the box
on the webpage. I want to show my check boxes checked if the value in
these fields are qr02a,qr02b,,,,. which means i have to have the data
values for my check boxes same as the values in the field.

Thanks
 
Back
Top