default value for check box with existing data

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.

How about just setting the default value to True.

--
_________

Sean Bailey


"LisaK" wrote:

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'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.
--
Dave Hargis, Microsoft Access MVP


"LisaK" wrote:

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.

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.


"Klatuu" wrote:

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.
--
Dave Hargis, Microsoft Access MVP


"LisaK" wrote:

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.

Would I do this in the table or the form?


"Beetle" wrote:

How about just setting the default value to True.

--
_________

Sean Bailey


"LisaK" wrote:

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.

In the table.
--
_________

Sean Bailey


"LisaK" wrote:

Would I do this in the table or the form?


"Beetle" wrote:

How about just setting the default value to True.

--
_________

Sean Bailey


"LisaK" wrote:

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.