ACCESS SQL- Using 'LIKE' with a Field on a form

[jase2006]

Can any tell me how I can using the keyword LIKE to compare a table field with a textbox on a form e.g.

X.user LIKE '* Form Text box value *'

I've tried something like this

(([Skill Import].User)LIKE '*' & [forms]![frmSkillView].[txtUser])) & '*'

but does seem to work.

 

[AlexCuse]

You need to specify the property of the text box

like this:

[Skill Import].User LIKE '*' & [forms]![frmSkillView].[txtUser][b].Value[/b] & '*'

In the future, for access questions please try forum701

hope this helps,

Alex



Ignorance of certain subjects is a great part of wisdom