How to use user input from textbox in function (ie. DCount)

[behnam]

Hi all,



For one of my queries i use the function Dcount in the form

Text16 = DCount("[Resolved?]", "Power Outages", "[Resolved?]=true AND [Date Added] like '*2014'")

this basically counts all the records in the table Power Outages which has Resolved=true and the last 4 characters of the string date Added has to end in 2014. This works. Now im taking it a step further and allowing user input. i have a textbox called Text188 and the user enters the year. based on what they enter I would like to modify the code so instead of 2014 its the year they entered.

I tried:

Text16 = DCount("[Resolved?]", "Power Outages", "[Resolved?]=true AND [Date Added] like '*Text188'")

but the following does not work. Can anyone tell me how to do this.

All the Best,
Ben.

[ranman256]

The text box must resolve outside the quotes...

Text16 = DCount("[Resolved?]", "Power Outages", "[Resolved?]=true AND [Date Added] like '*" & text188 & "'")

[behnam]

Thank You very much for your help.