I am setting up a form that will run through 95 existing records. There are various questions associated with each record, such as condition and operation status. For each question of condition I specified a combo box with a value list with "Good";"Fair";"Poor". For each question of operation status I have a Yes/No with a check box.
Each year these 95 records are ran through and the questions are entered. To save time is there a way that each question of condition have a default answer of Good, and for each Yes/No question to have a default answer of yes.
I see you can specify a default value in the design view of a table but that only enters the specified default value for new records entered.
I have very minimal experience with any database program and minimal experience writing code, so hopefully this can be done with a simple control or simple code.
I'm assuming you have combos and check-boxes on a form but I'm not clear how you record the data: do the values from the questions get saved to a new table each time or are they appended to the same table?
Have you considered setting the default values of your controls on your form?