View Single Post
  #2 (permalink)  
Old August 30th, 2005, 05:58 PM
danbush danbush is offline
Authorized User
 
Join Date: Aug 2005
Location: , , .
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default

You should have an opening " mark as the one before the & is the end of the literal string and the & is joining the first part to the current value of the textbox item's itemdaa property. So, your whole select statement should look like this:

"select * from ans_table, ss_table where ss_table.qnsID = " & List1.ItemData(List1.ListIndex)

does this help?
Reply With Quote