How do you code checkboxes to show up whether you are adding the data by ticking the check box or editing it. I have the following code to load a checkbox in the form load section but it returns an Data Type converion error.

If Check1(0).Value Then
mRstrans!LightEater = "Yes"
Else
mRstrans!LightEater = "No"
End If
i have tried check1(0).value = 0 then , changed the no to "" and i still cant get it to work. If you have any ideas i would be greatful and will thank you in advance.