B
Bill
Hi,
I have dropdown menu for Country, State and City. It related each other
like USA, Califorina, Los Angeles, USA, Florida, Tampa Bay, etc. I have a
problem with single quoate that get an error. Is this a right code or did
i miss anything?
vStateQuery = "select distinct State from Country_Master where State='" &
vState & "' AND Country ='" & vCountry & "'"
State.RowSource = vCityQuery
St. Paul's (get error message)
St. Paul s (it works, no single quoate)
You help would be appreciated.
Thanks
I have dropdown menu for Country, State and City. It related each other
like USA, Califorina, Los Angeles, USA, Florida, Tampa Bay, etc. I have a
problem with single quoate that get an error. Is this a right code or did
i miss anything?
vStateQuery = "select distinct State from Country_Master where State='" &
vState & "' AND Country ='" & vCountry & "'"
State.RowSource = vCityQuery
St. Paul's (get error message)
St. Paul s (it works, no single quoate)
You help would be appreciated.
Thanks