How can I set a "CONTAINS" filter from query in a form.

[erickfloyd]

Hi, ActuallyI'm just call the query field from the form textbox, but I need use asterisk before and after the search word as follow

[ranman256]

qsLikeQry= select * from table where [contenga] like forms!myForm!txtContenga

(but note, this wont work when you DONT use asterisks, so you may need an IF)

IF instr(txtContenga,"*")>0 then
   docmd.Openquery "qsLikeQry"
else
   docmd.Openquery "qsExactQry"
endif

[erickfloyd]

Thanks, but I'm Still without Known where should I Put the query column name that i want to search


IF instr(Text97,"*")>0 then
docmd.Openquery "SADOS_CONT"
else
docmd.Openquery "SALDOS_CONT"
endif


These only open the query "SALDOS_CONT" but don't search or filter tha column that i want.

[aytee111]

Try Like "*" & forms!formname!fieldname & "*"

[erickfloyd]

Thank you, that's finally works.