Access Form help

[pkondilys]

I have this form I've created, ok? There are 2 fields Date and Time. I want every time you enter a new record to automatically input the current time and date into the corresponding fields. I know how to do that...my problem is that the values will not save into the table. This way when I pull a report it will have the date and time stored. I don't want to enter the values manually.....
Any help would be great....

 

[fneily]

Your form should be "linked" to a table. Does your table have the fields Date and Time in it? If it does, when you created your form, I presume through Form Wizard, these boxes would automatically be "BOUND" to the table fields. If they're not, go to design view of your form, click on the text box of one of controls, bring up it's Property Sheet, and click on the box next to Control Source. Click on the drop down arrow and select the appropriate field in your table.

Neil

 

[pkondilys]

Hey, thanks. i did go back and link the tables to the form and got the results I needed.