cant addnew to dataset when form has a checkbox

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

Guest

my data is an access mdb. the table has several columns of strings, booleans, dates, etc. i noticed that when i include a bound checkbox to a boolean (yes/no) column to my form that i cant add a new row to the table. but when i remove the checkbox and replace it with a text box that the problem goes away. the textbox shows true/false which is fine. but the user would have to type in true or false which is not practical. i assume that there is a property for the checkbox that i need to correct but i dont know which one. any advice? thanks in advance.
 
What property were you binding to? It should be checked.
sny said:
my data is an access mdb. the table has several columns of strings,
Click to expand...
booleans, dates, etc. i noticed that when i include a bound checkbox to a
boolean (yes/no) column to my form that i cant add a new row to the table.
but when i remove the checkbox and replace it with a text box that the
problem goes away. the textbox shows true/false which is fine. but the
user would have to type in true or false which is not practical. i assume
that there is a property for the checkbox that i need to correct but i dont
know which one. any advice? thanks in advance.
 
the column is bound to the checkbox's Checked propert

(i used the data form wizard to create this form)
 
Hi Sny!

These links may be useful ...

http://support.microsoft.com/default.aspx?scid=kb;en-us;326440
http://support.microsoft.com/default.aspx?scid=kb;EN-US;321504

sny said:
my data is an access mdb. the table has several columns of strings,
Click to expand...
booleans, dates, etc. i noticed that when i include a bound checkbox to a
boolean (yes/no) column to my form that i cant add a new row to the table.
but when i remove the checkbox and replace it with a text box that the
problem goes away. the textbox shows true/false which is fine. but the
user would have to type in true or false which is not practical. i assume
that there is a property for the checkbox that i need to correct but i dont
know which one. any advice? thanks in advance.
 
Back
Top