Forums
This topic is locked
make update record form show state of check box
Posted 09 Jul 2003 23:35:33
1
has voted
09 Jul 2003 23:35:33 david j johnson posted:
Using DWMX and sql I am tring to show a checkbox checked in the update form. so I don't have to check it each time I do an update Replies
Replied 11 Jul 2003 23:31:06
11 Jul 2003 23:31:06 Roger Smithe replied:
I've just been thru this
First I am using an Access2002 datafile
- In Access the checkboxes are set as Yes/No
- Starting with the INSERT behavior on the form, the checkboxes are submitted as 'Checkbox 1,0'
- For the UPDATE behavior on the Edit form Select and add a Dynamic Checkbox (from the Server Behavior->Dynamic Elements selection)
- Set it to look at the checkbox your working with (the lightning bolt)
and for 'Check if' type in 'True' (do not include single quotes)
<img src="208.20.124.24/checkbox.jpg" border=0>
That should work
First I am using an Access2002 datafile
- In Access the checkboxes are set as Yes/No
- Starting with the INSERT behavior on the form, the checkboxes are submitted as 'Checkbox 1,0'
- For the UPDATE behavior on the Edit form Select and add a Dynamic Checkbox (from the Server Behavior->Dynamic Elements selection)
- Set it to look at the checkbox your working with (the lightning bolt)
and for 'Check if' type in 'True' (do not include single quotes)
<img src="208.20.124.24/checkbox.jpg" border=0>
That should work