I have three list boxes, one to capture the ID number (number), the City (text) and Area (text).
There is a button that pulls all the responses in the following variables:
strID
strCity
strArea
The SQL string is the following:
Expand|Select|Wrap|Line Numbers
- strSQL = "SELECT tbMaster_A.* FROM tbPrograms " & _
- "WHERE tbMaster_A.[GrID] = " & strID & _
- strCityCondition & "tbMaster_A.[City]" & strCity & _
- strAreaCondition & "tbMaster_A.[Area]" & strArea & "';"
strCityCondition
strAreaCondition
I thought by making the string equaling the variable would resolve it. When I removed the equals sign and replaced with the ampersand &, to concatenate the string.
There was no change.
How can I make the [GrID] string accept a numeric user entry?
Thanks.