Can a sql query update a field in a Access db with a 'null' value 1

[ajap99]

I have a field in an access db that contains a number when it is booked.
When I delete a booking I want to set this field back to being empty.
I am using the following SQL statement.This works when eg i put a 1 into textbox12



strDelete = "Update ResourceDates Set BookingRef=(" &"'" & textbox12.text &"'" &") WHERE ResourceDatesID=" & RID

Is this possible ?

 

[HarleyQuinn]

Try:

"Update ResourceDates Set BookingRef=Null WHERE ResourceDatesID=" & RID

Hope this helps

Harleyquinn

---------------------------------
For tsunami relief donations