syntax error (missing operator) 3075

[steve proctor]

hi
am i trying to up date the table book from tblTransfer2
and i am getting the above error but no clues as to what the missing operator could be, it works in access query in an update query but doesn't seem to like vb? any clues?

sql = "SELECT book INNER JOIN tblTransfer2 ON book.SeatID = tblTransfer2.SeatID"

Set recset = dbAbbeytheatre.OpenRecordset(sql)

recset.Edit
Do While seatid = seatid
recset!book = True
recset!bookdate = bookdate
recset!bookedby = bookedby
recset.update
recset.MoveNext
Loop
steve

[MikeTheBike]

Hi
Perhapse this may get you a little further

sql = "SELECT book.* FROM book INNER JOIN tblTransfer2 ON book.SeatID = tblTransfer2.SeatID"

I don't use DAO recordset, but from memeory I think you need to us the recset.Edit method befor you can edit/update!?

HTH


MTB

[steve proctor]

thanks HTH or is it MTB???
it certainly moved it on to the next bit the "recset.edit"
now it seems to have a when it gets to"recset!bookdate" problem with date type conversion error 3421, its showing recset!bookdate (null) and the bookdate (""),i presume it's not seeing whats in tbltransfer2 which i can't understand because both tables have the same data type (date/time ,number)