Replacing a date field with null value

[AOGFADUGBA]

Hi all, i have a command button which is meant to replace a number of fields with a null value in a link table.
the problem is all other fields are replaced with the null value except the date field. below is the vba code i used


Private Sub Command501_Click()
Status = "UNPAID"
DeptNo = ""
PVNo = ""
VoteBook_subform2.Form.[Voucher No] = ""
VoteBook_subform2.Form.[RSubHead] = ""
VoteBook_subform2.Form.[Date] = "null"
VoteBook_subform2.Form.[Head] = ""
VoteBook_subform2.Form.

 = ""
VoteBook_subform2.Form.[Particulars] = ""
VoteBook_subform2.Form.[Payments] = ""
End Sub


i keep getting error from the date field even when i replaced the "null" with "". please what am i doing wrong???
Thanks

 

[alansidman]

Is the command button on the subform or another form?

I believe the issue is the name of the control on the subform. Date is a reserved name in Access. Change the control name and try it.

Here is link to names that should not be used: https://support.office.com/en-us/ar...-symbols-e33eb3a9-8baa-4335-9f57-da237c63eabe

 

[james_lankford]

none of those are replaced with NULL

an empty string "" is not NULL

if you want to replace with NULL then use NULL

VoteBook_subform2.Form.[RSubHead] = NULL
VoteBook_subform2.Form.[Date] = NULL
and so on

 

[AOGFADUGBA]

Hi Tried with VDate still didn't work, both with NULL and "".
How do i do it?
Thanks

 

[alansidman]

What is the error message you get and when you get the message and click on debug, which line of code is highlighted?

 

[AOGFADUGBA]

The error message is "you must enter a value in the date field" i think i have located where the error is coming from. the date field is a required field. so i changed required to No and it worked. although i still need to check why i made the Date field in the votebook table a required field.
Thanks so much.