If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
default value for check box with existing data
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. |
#3
|
|||
|
|||
default value for check box with existing data
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. |
#4
|
|||
|
|||
default value for check box with existing 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. "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. |
#5
|
|||
|
|||
default value for check box with existing data
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. |
#6
|
|||
|
|||
default value for check box with existing data
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. |
Thread Tools | |
Display Modes | |
|
|