HELP TABLES!!

[Guest]

I am not quite sure what I did but, I was had already started a table and had
some data in it, when we had to change the table, so I did and now it is
linking the items that we added to every form and not letting me choose
wheather they need to be entered or not. WHAT DO I DO?????

 

[John W. Vinson]

I am not quite sure what I did but, I was had already started a table and had
some data in it, when we had to change the table, so I did and now it is
linking the items that we added to every form and not letting me choose
wheather they need to be entered or not. WHAT DO I DO?????

Calm down, take a deep breath, and post a comprehensible question.

We do not know anything about the structure of your table.
We do not know what change you made.
It's not at all clear what "linking the items" means.
I have no idea what you mean by "not letting me choose whether they need to be
entered or not".

Please post some more information about the structure of your database, and
what specifically is happening.

John W. Vinson [MVP]

 

[Guest]

OK! I work for a Boys home and we are trying to track their daily events.
We have been tracking for about 10 months and someone decided that they
needed more information on the form. So I added weather they attended public
school or not and if they had any school activities. I made both of these
questions yes or no. Now when I go to the form to enter the data in when I
check yes it checks yes for all of the records. I need to be able for some
of the records to be no. Sorry about the confusion.

 

[John W. Vinson]

OK! I work for a Boys home and we are trying to track their daily events.
We have been tracking for about 10 months and someone decided that they
needed more information on the form. So I added weather they attended public
school or not and if they had any school activities. I made both of these
questions yes or no. Now when I go to the form to enter the data in when I
check yes it checks yes for all of the records. I need to be able for some
of the records to be no. Sorry about the confusion.

The point to remember is that the Form *does not store anything*. It's just a
window, a tool to edit data; the data is stored in your Table, and only in
your table. Adding a checkbox on the form (and just the form) will do just as
you describe - its value is not stored anywhere.

You need to add yes/no fields *to the Table* upon which the form is based. You
will then probably need to open the Form in design view; view its Recordsource
property; and be sure that the newly added fields are included in the
recordsource. You can then set the Control Source property of each of these
new checkboxes to the appropriate table field.

John W. Vinson [MVP]