I am attempting to run this update query from code and I keep getting a
message that says "you are about to update "0" records". The query
does not update the table at all. These are linked tables in a back
end mdb. What am I doing wrong?? The code is as follows.....

Thanks for the help
Mike



Dim strsql As String
Dim BD As String
Dim ED As String

BD = Me.BDate
ED = Me.Edate

strsql = "UPDATE tblDateCarry SET tblDateCarry.Bdate = " & BD & ",
tblDateCarry.EDate = " & ED & ";"
DoCmd.RunSQL (strsql)

Michael wrote:
ED and BD should be defined as DATES not STRINGS. Are there any
records in your table? what happens if you turn the thing into a
select query? Does it return records?

"Michael" <MUB (AT) verizon (DOT) net> wrote


It might be a good idea to Debug.Print the strSQL instead of running it -
you might then see the problem in the string. You need to be careful with
dates and formatting them - but the following gives two possible examples to
do the same thing:

SET tblDateCarry.Bdate = '2004-06-23', tblDateCarry.EDate = '2004-07-25'

SET tblDateCarry.Bdate = #6/23/2004#, tblDateCarry.EDate = #7/25/2004#