DB DESIGN FIELD

[Ismael]

I created a db using access xp. THe way I did it is by following the
contack management wizard to the point I could create my customized
design. Well, I did it and after I clicked the View button to the
design view I deleted some fields I did not need. And then I tried to
create a check mark field where I can keep track of students courses
they have taken. For example, Math, Social Studies, etc. and next
to the course I isnerted the check mark wich is located in the Toolbar
Options. Well, I changed back to From view and tried the db. I
clicked the check mark it it worked! However, when I created another
record, the check mark was already checked!!!!! and if I unmarked the
check mark, it appears unmarked in every record!!!!

PLEASE I will appreciate you help, how can I fix this prroblem?????

[Salad]

Re: DB DESIGN FIELD

Ismael wrote:
[color=blue]
> I created a db using access xp. THe way I did it is by following the
> contack management wizard to the point I could create my customized
> design. Well, I did it and after I clicked the View button to the
> design view I deleted some fields I did not need. And then I tried to
> create a check mark field where I can keep track of students courses
> they have taken. For example, Math, Social Studies, etc. and next
> to the course I isnerted the check mark wich is located in the Toolbar
> Options. Well, I changed back to From view and tried the db. I
> clicked the check mark it it worked! However, when I created another
> record, the check mark was already checked!!!!! and if I unmarked the
> check mark, it appears unmarked in every record!!!!
>
> PLEASE I will appreciate you help, how can I fix this prroblem?????[/color]

Is the Checkmark, Yes/No, a field in the table upon which the form is
bound to? If not (as I suspect), open up the table the form is bound to
and add a Yes/No field to the table.

[Squirrel]

Re: DB DESIGN FIELD

It sounds as though you have put an unbound control on your form. First add
a new field (boolean) to your table, then select that field in the field
list and drag it onto your form while in design mode. Then you'll have a
checkbox with every record.

HTH Linda

"Ismael" <ismael.hertz@v erizon.net> wrote in message
news:8adfe974.0 409062019.2dda2 ad0@posting.goo gle.com...[color=blue]
> I created a db using access xp. THe way I did it is by following the
> contack management wizard to the point I could create my customized
> design. Well, I did it and after I clicked the View button to the
> design view I deleted some fields I did not need. And then I tried to
> create a check mark field where I can keep track of students courses
> they have taken. For example, Math, Social Studies, etc. and next
> to the course I isnerted the check mark wich is located in the Toolbar
> Options. Well, I changed back to From view and tried the db. I
> clicked the check mark it it worked! However, when I created another
> record, the check mark was already checked!!!!! and if I unmarked the
> check mark, it appears unmarked in every record!!!!
>
> PLEASE I will appreciate you help, how can I fix this prroblem?????[/color]