R
rogge
How do I default check boxes to False (un-ticked) with ADODB connection? and
other strange behaviour... thank you
the form has four (4) check boxes. When a user clicks the "New Record"
button (programmed for a good UI - goes to new record, disables some
navigation controls, etc...) and enters data into any control all the check
boxes become ticked.
I have tried
• setting the defaults on the table to -1, 0, and 1.
• setting the defaults on the check boxes to -1, 0, 1, and False
• toggleing "retrieve defults" for the form between "Yes" and "No"
• programatically setting the check boxes to un-ticked on the "On Dirty" Event
Other behavior:
Clicking the check boxes wth the mouse only ticks the boxes; one can't
un-tick the boxes. HOWEVER, pressing the space bar will tick/un-tick the
active control.
ADODB Connection
BE: MS SQL Server 2000 SP4 / WinServer 2003 SP(Latest)
FE: MS Access 2003 (XP) / Win XP SP2
Form: Unique table is set
Form: Resynch command is set
Check box: Triple state = no
other strange behaviour... thank you
the form has four (4) check boxes. When a user clicks the "New Record"
button (programmed for a good UI - goes to new record, disables some
navigation controls, etc...) and enters data into any control all the check
boxes become ticked.
I have tried
• setting the defaults on the table to -1, 0, and 1.
• setting the defaults on the check boxes to -1, 0, 1, and False
• toggleing "retrieve defults" for the form between "Yes" and "No"
• programatically setting the check boxes to un-ticked on the "On Dirty" Event
Other behavior:
Clicking the check boxes wth the mouse only ticks the boxes; one can't
un-tick the boxes. HOWEVER, pressing the space bar will tick/un-tick the
active control.
ADODB Connection
BE: MS SQL Server 2000 SP4 / WinServer 2003 SP(Latest)
FE: MS Access 2003 (XP) / Win XP SP2
Form: Unique table is set
Form: Resynch command is set
Check box: Triple state = no