vba like

  • Thread starter Thread starter Grimwadec
  • Start date Start date
G

Grimwadec

ElseIf Me.FitSize.RowSource = "Like *,*" Then

is the code I wrote in attempt to get the code to recognise where RowSource
equals say "Ladies,Mens", also tried [] around the comma

of course it doesn't work because I don't have a clue as to how to include a
Like operator in VBA. Help please
 
I think you're going to need to include that in an SQL statement to return
any results...

Me.FitSize.Rowsource = _
"SELECT * FROM tablename " & _
"WHERE [field] LIKE ""*,*"""

I'm not 100% sure on that syntax but it's closer than what you have at the
moment.

hth

--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)
 
ah, so Like really means =Like...thanks, so simple really!
--
Grimwadec


Dale Fye said:
Grim,

Try:

Elseif me.FitSize.Rowsource Like "*,*" Then


----
HTH
Dale



Grimwadec said:
ElseIf Me.FitSize.RowSource = "Like *,*" Then

is the code I wrote in attempt to get the code to recognise where RowSource
equals say "Ladies,Mens", also tried [] around the comma

of course it doesn't work because I don't have a clue as to how to include a
Like operator in VBA. Help please
Click to expand...
Click to expand...
 
Back
Top