Filter button to Filter by 2 fields

[dee]

I'd like to filter by the following criteria:

left(LeadDisposition,3) = "Sit" AND Appt_Date = Text767

I have no idea how to do this. Appreciate help.

 

[Guest]

Filter what?

 

[dee]

Filter what?

Show only those records of the form 'FmLeads' where the leftmost 3
characters of the field 'LeadDisposition' ="Sit", and where the value
of the field 'Appt_Date' = the value of the field 'Text767'.
The form is already open. To activate the filter, a button is pressed.

 

[Guest]

Put the code in the Click event of the button

Me.Filter = Left(LeadDisposition,3) = "Sit" AND Appt_Date = Me.Text767
Me.FilterOn = True

 

[dee]

Put the code in the Click event of the button

Me.Filter= Left(LeadDisposition,3) = "Sit" AND Appt_Date = Me.Text767
Me.FilterOn = True

Thanks Dave, but it does not work.
When I press the button, it only shows 1 new empty record.
There are about a dozen or so qualifying records to display.

 

[Guest]

Try changing it to
Me.Filter= Left(LeadDisposition,3) = "Sit" AND Appt_Date = "#" & Me.Text767
& "#"

 

[dee]

Try changing it to
Me.Filter= Left(LeadDisposition,3) = "Sit" AND Appt_Date = "#" & Me.Text767
& "#"

Still does not work Dave.

 

[Guest]

Is LeadDisposition a field in the form's record source?
If so, is it a text data type?
Is APPT_DATE a date field?
If so, does it contain only a date or does it contain date and time?

 

[dee]

Is LeadDisposition a field in the form's record source?
If so, is it a text data type?
Is APPT_DATE a date field?
If so, does it contain only a date or does it contain date and time?

LeadDisposition is a text field
APPT_DATE is a date field formatted as 'ddd dd mmm yy' medium date
only in both 'Appt_Date' and 'Text767'.

By the way, I got part of it working,

Me.Filter = "left(LeadDisposition,3) = 'Sit'"

Can't get the rest working Dave.

 

[Guest]

Sorry about that. Try this version.
Me.Filter= "Left(LeadDisposition,3) = 'Sit' AND Appt_Date = #" & Me.Text767
& "#"