combo box problem

[gasx]

why this code work on text box and is not working with combo box. I have form with text box when I insert this code is work.

If Me.text1 <= orderDate Then
MsgBox &quot;my message ,&quot; & vbCrLf &quot;&quot;vbExclamation,
&quot;title&quot;

but when I insert same code on combo box is not working.

If Me.combo1 <= orderDate Then
MsgBox &quot;my message ,&quot; & vbCrLf &quot;&quot;vbExclamation,
&quot;title&quot;

what I did wrong. please help.

 

[scriverb]

Where are you putting the code in the combobox? After Updat event procedure. That makes the most sense.

Also, check to see if the bound column is set to the column of the date from the row source in the combobox. If it is set to a different column that the one that has the date info it will not execute properly.

Bob Scriver

 

[scriverb]

Also, you may have to perform a DateValue or CDate function on the Combobox data to convert a string entry to a datevalue.

If DateValue(Me.combo1) <= orderDate Then
MsgBox &quot;my message ,&quot; & vbCrLf &quot;&quot;vbExclamation,
&quot;title&quot;

Just a couple of suggestion to my original post.


Bob Scriver