Automatic Date Loading

[cchampagne17]

Hello all,

I'm relatively new to the Access scene so I really don't know much beyond the basics regarding Access so I was wondering if anyone could help me.

I created a form that an inspector will fill out each time they make a data recording. However each time they make a new recording they have to refill each text/combo box (date, color, painter, etc.), which is a giant pain for the person entering data. I was wondering how one would go about creating a... macro?... so that the date automatically loads for each new form based on whatever the date is that they are doing the recording.

If you could also describe to me how I would keep the combo box criteria the same in each new form (but still be changable if the scenario changes... EX. painting the color black until the color changes to brown) that would be great! Thank you so much!

 

[jzwp22]

For both the text box and combo box controls there is a default value property. For the date textbox you can set the default value to date() which will show the current system date when you are on a new record. You can do the same for the combo boxes, but that default value will always be the same. It will not change as new records are added. I believe that you could use some code to change the default value, but that is something I have never tried.

 

[Anakardian]

Have you considered a subform to record the varying details of each inspection?
Depending on what and how you are recording the data it might be a better way.