default value for check box with existing data

[LisaK]

I have a form that we have been using for a couple of years so it has alot of
existing data in it. I would like to make a change to one of the subforms
and have 3 current check boxes automatically be checked when I append new
data. How do I do this without changing the existing data? I am a very
basic access user so I do not know how to code or anything fancy.

Thanks.

 

[Beetle]

How about just setting the default value to True.

 

[Klatuu]

Beetle's answer is correct. That is all you need to do. It will not affect
existing records, it will only make the field in the existing records = True.

The reason I responded to you post is because you either are mistating or
you have an incorrect understanding of where data is.

Forms do not contain any data. They only present data on the screen. All
data is held in tables. Queries can be used to extract data from tables to
present a recordset. Forms have a record source property that identifies
which query or table to use to manipulate the data.

 

[LisaK]

Yes I do know that the form does not contain the data and it is stored in a
table. My question was just worded wrong.

 

[LisaK]

Would I do this in the table or the form?

How about just setting the default value to True.

 

[Beetle]

In the table.
--
_________

Sean Bailey

Would I do this in the table or the form?