The Now() Function returns the current Date and Time.

__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"

thank... but how do i implement this function into the vb script page in the access form...??

Well let me get this straight you have a form which is probably used for recording issue of inventory, and on that form you have a field that you want to record the time at which the inventory is issued. You want the time (current time and date) to be automatically recorded when you fill up the form and save the data. If this is your criteria here is my solution:

You need to create a command button. When you do so the Wizard opens. Go to Record Operations. Select Save Record and create the button. The Code marked red will be created automatically for you.

Now I have a form in which I have a field called Date. In this field I will record the current date and time. Right Click the Save Command Button that you have created go to the Click Event and open the Vb Code. Add the Line that is in black in the code. This will do the trick. Remember to select general Date format when you are designing the table.

Private Sub Command6_Click()
On Error GoTo Err_Command6_Click

Me.Date = Now()
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

Exit_Command6_Click:
Exit Sub

Err_Command6_Click:
MsgBox Err.Description
Resume Exit_Command6_Click

End Sub

Please mark this thread as solved if it solves your problem.

It is really not a good idea to have a field named Date since it is a reserved word.
http://www.allenbrowne.com/AppIssueBadWord.html

__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"

Rural Guy is right it is no a good idea to use a reserved word as a field name. But the point is just type use the code with the field name that you have in your data base.

I am just curious whether you were able to solve your problem? If yes please mark this thread to be solved. This will help others who may be facing a similar problem and wants quick solution.