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,
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,
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top