Search Form COde Help!!!!!

[THREE05]

on my search button I got this for one criteria , DoCmd.ApplyFilter , "[Doctor_Name] Like ""*"" & [Forms]![Search_F]![Txt1] & ""*"""

I want to search by

Folder_Name
Date
Room
Birth date.

I have tried "or" after ""*""" but doesn't work,, Help please.

 

[Ranman256]

I think you have too many quotes.
Try single quotes...
Like '*" & me.txt & "*' "

You don't need the full path in vb code if you are in the form.
If not in the form, you can use a query instead of SQL.

 

[THREE05]

Dang :banghead: I cant get this. can you help me put it together? please?

I got this fields. Doc_Name, Pat _Name, Case, Date,
my forms name is "Search_F"

 

[isladogs]

EDITED ANSWER - my original answer was wrong as I realised after answering another post

Try this

 "[Doctor_Name] Like ""*" & Me.txt1 & "*"""

I recommend Allen Browne's website for help with syntax in such cases:
http://allenbrowne.com/ser-62code.html