Changing boolean values retrieved from Access DB

[gcadmindude]

I've created an Access 2003 DB that I'm using to store text fields that need
to be passed between Infopath 2003 forms. The Access DB also has a few
boolean fields in each record that I want to use as flags to identify the
record I want to pull in when switching from form to form.

I can query and submit the text fields without a problem. But the boolean
fields seem to be coming into the IP form as a non-standard type. In
otherwords, while the value from the database is pulled into the form without
error, none of my attempts to change the default value within the IP form
works.

I'm using a button to switch forms. Behind the button are a number of
rules. One of those rules sets the value of the boolean field from the
Access DB using the built in function True(). However this doesn't actually
work.

I've dragged the boolean field into the form to see the actual data as I'm
attempting to change it from the default of false, to true. For whatever
reason, the boolean field becomes a combo box instead of the expected check
box typically associated with a boolean field.

The boolean field is initally 'false'. After the code behind the button is
run to change the value to 'true' the boolean field displays 'select'.

I've had our SQL database admin look everything over in both the Access
database and the IP form and he swears it should work....I thought this would
be a simple matter but it's got me totally stumped!

HELP!!!!!

Sincerely,
Dazed and Confused

 

[myost]

I've created an Access 2003 DB that I'm using to store text fields that need
to be passed between Infopath 2003 forms. The Access DB also has a few
boolean fields in each record that I want to use as flags to identify the
record I want to pull in when switching from form to form.

I can query and submit the text fields without a problem. But the boolean
fields seem to be coming into the IP form as a non-standard type. In
otherwords, while the value from the database is pulled into the form without
error, none of my attempts to change the default value within the IP form
works.

I'm using a button to switch forms. Behind the button are a number of
rules. One of those rules sets the value of the boolean field from the
Access DB using the built in function True(). However this doesn't actually
work.

I've dragged the boolean field into the form to see the actual data as I'm
attempting to change it from the default of false, to true. For whatever
reason, the boolean field becomes a combo box instead of the expected check
box typically associated with a boolean field.

The boolean field is initally 'false'. After the code behind the button is
run to change the value to 'true' the boolean field displays 'select'.

I've had our SQL database admin look everything over in both the Access
database and the IP form and he swears it should work....I thought this would
be a simple matter but it's got me totally stumped!

HELP!!!!!

Sincerely,
Dazed and Confused

Hah! I found a work around for this, although I suspect it's a bug in
the design.

1- create a text field in the form
2- set the text field to "True", action= set value, select your text
field, open the function creator and type "True"
3- set the database field = to your text field
done!