Assigning Date to query field

[lleung]

On a Form when assigning Date to a query's field, in need of help with the 2448 error message (You can't assign a value to this object) for the following:

If Form!SCHDATE.Value = DateValue(Form!SchdateParm.Value) Then
Let ScheduleLetter1.Value = Date

In the above, the query fields are "SCHDATE" and "ScheduleLetter1".

"ScheduleLetter1" is defined in the table as Date/Time and the initial value is NULL.

I have attempted "Form!ScheduleLetter.Value" and "Me!ScheduleLetter.Value" without success.

Thank you for any help with the above.

 

[Travis]

Take out the .Value

 

[lleung]

Unsuccessful with removing the ".Value". VBA Debugger still displays "2448 error".

The error was due to the need in the Form's Recordset property setting to be "Inconsistent Updates". The need was caused by the query containing more than one table.

 

[Travis]

Take out the "Let"

(I appoligize I didn't see it the first time I read your post)

If Form!SCHDATE = DateValue(Form!SchdateParm) Then ScheduleLetter1 = Date