default value for check box with existing data

  • Thread starter Thread starter LisaK
  • Start date Start date
L

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'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.
 
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.
 
Back
Top