A little help please.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a checkbox on a form, we'll call it CHECK. I also have a yes/no field
in a table that gets data from the form, we'll call it START. This form fils
in fields on several tables, so there's some code behind it, in VB.

What I want is for CHECK to determine the value of START in the code. I've
tried all sorts of configurations that look like this, more or less:

If CHECK Then
START=1
Else START =0
End If

I've tried making START be TRUE, 1, Yes, and On. The problem is that when
the table gets updated (using the rst!Update function), when START should
have a value of 1 (since CHECK was marked), it has a value of -1. Can anyone
set me straight?

~Yb
 
Access stores True as -1.

If it's critical that you have 1, you can either set the field to Byte, or
you can use Abs([Start])
 
Back
Top