Hi
I need help on this.
I have a command button named “CmdSlot “on a form that I am trying to use to return all the dates in the table “inspection_details” which have the same date as the date on an unbound text box named “slot”
Private Sub CmdSlot_Click()
MsgBox DCount("*", "Inspection_details", "Inspection_date = " & Me!Slot)
End Sub
But, the message box returns 0 all the time.
How can I resolve this?
I need help on this.
I have a command button named “CmdSlot “on a form that I am trying to use to return all the dates in the table “inspection_details” which have the same date as the date on an unbound text box named “slot”
Private Sub CmdSlot_Click()
MsgBox DCount("*", "Inspection_details", "Inspection_date = " & Me!Slot)
End Sub
But, the message box returns 0 all the time.
How can I resolve this?