Miikka Hamalainen wrote:
If Date() [the current date] is not recognized as a valid function when
you execute the INSERT INTO, you have to pass it as a parameter. You can
use its value+28 for [return date] then.

Could it be that simple?

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea

Why is it imperative that you must us an SQL command to add this to
your fields?

I would think that having a form with the option to change the value
would be better.

If you really must have a SQL Statement you could just do something
like:

Private Sub Loaned_Date_DblClick(Cancel As Integer)

If IsNull(Me.Loaned_Date) Then
Exit Sub
End If

Me.Loaned_Date = Date
Me.Refresh

$returnDate = = DateAdd("d", 28, Me.Loaned_Date)

DoCmd.RunSQL "UPDATE myTable SET returnDate = '" & $returnDate & "'
WHERE LoanId = '" & $loanId & "';"

End Sub