The information in the textbox is, I believe, being treated as text which is
not equal to a numeric date value.

try:
CDate(Me.TextBox1.Value) to convert the text date to numeric value.


"ll" wrote:

On Jun 12, 8:18 am, ll wrote:
On Jun 11, 7:09 pm, Gary''s Student

wrote:
What is b and where is it set??
--
Gary''s Student - gsnu200728

Oops - here's the missing code - b is set to the ListIndex of the
combo box:

b = Me.CboLeaveType2.ListIndex



The odd thing is that I can have text (i.e. "car 4") on sheet2 and
have a cell in sheet1 reference it, but when I try doing a date from
sheet2 (or sheet1) and comparing it to the date in my textbox, the
code runs without error but produces no result.