Filter syntax problems

  • Thread starter Thread starter Ticotion
  • Start date Start date
T

Ticotion

Hi

I need to filter a form using a two comboboxes ones containing dates and
another containing a name. I use the following code but can't ge the syntax
right.

Me.Filter = "[Line] = " & Me.combo144& " And [Datem]=#" & Me.combo136 & "#"
Me.FilterOn = True

Please Help

Ticotion
 
The combo box containing a name is text so you need top enclose it in single
quotes
"[Line] = '" & Me.combo144& "' And [Datem]=#" & Me.combo136 & "#"
 
thank you. That worked

/Ticotion

RonaldoOneNil said:
The combo box containing a name is text so you need top enclose it in single
quotes
"[Line] = '" & Me.combo144& "' And [Datem]=#" & Me.combo136 & "#"

Ticotion said:
Hi

I need to filter a form using a two comboboxes ones containing dates and
another containing a name. I use the following code but can't ge the syntax
right.

Me.Filter = "[Line] = " & Me.combo144& " And [Datem]=#" & Me.combo136 & "#"
Me.FilterOn = True

Please Help

Ticotion
Click to expand...
Click to expand...
 
Back
Top