I have a SQL table called "WorkOrders" set up with the following fields:
nItemID varchar 12 allow nulls=yes
stFileName nvarchar 50 allow nulls=no
...
nChargeStatus bit 1 allow nulls=no
...
I just can't get the dataform to set up for a new record entry!!!!!! Any Ideas ???
What's frustrating is, that, I've another form created the same way with a different table that works great. I can't see any differences other than table & field names
[Fortunately Fred solved his own problem with the help of Pat Carden.]
It turns out that either the
dataset or the dataform wizard has a problem with the "BIT" type. One of the
fields in my table was set to this and when I changed it to "integer" type
and re-built the dataform, it worked just fine.
|