If statement depending on part of string appearing inside combo va

[bUncE]

I hope the title makes sense, i'm still getting to grips with programming
terminology

Basically i have a combobox which will sometimes contain

DataDate...... or LoginDate..... or DateModified.... etc

I want an If statement to search the combobox value for the word "Date"

Like If Me.cboFields.Value [CONTAINS] "Date" Then

strSQL = ..................................................# date value #

Then if it does contain the words Date it will add some ##'s to my SQL
statement..

I haven't had any luck as of yet (with the If bit the ##s bit is cool) but
was hoping for a push in the right direction or something.

Muchos Gracias

Mike Harkess

 

[bUncE]

No worries managed to get it sorted