Problem with Update Command in Access

[anunat]

I am trying to populate the SaleDate column in my table using the UPDATE command.

Dim mydate As Date
mydate = DateValue("01/" & strmonth & "/" & stryear)
MsgBox ldate (shows date in mm/dd/yyyy format correctly)

When I try to use mydate in the UPDATE statement, I get the error: too few arguments.

CurrentDb().Execute "UPDATE 1 SET [SaleDate] = mydate;"



Can somebody help me with this?

If my method is completely wrong, can you please suggest how I can use a date variable in the UPDATE statement?

[pbaldy]

For starters, you're using 2 different variables, unless that's a typo. Second, you have to concatenate the variable, using the appropriate delimiter for date values:

CurrentDb().Execute "UPDATE 1 SET [SaleDate] = #" & mydate & "#"

Is your table really named 1?

[anunat]

Thanks so much. That worked.

Yeah I am just playing around so did name my table 1.

[pbaldy]

Happy to help, and welcome to the site.