sqllookup = "SELECT Stockqa.AnswerValue FROM Stockqa WHERE ((Stockqa.QuestionsID)= " & tempquestionsid & ") AND ((Stockqa.ClientID)= " & tempclientid & " );"
AnswerLookup.RowSource = sqllookup
(please excuse the test boxes..)
I am having a slight brain drain as I have been working on this for 2 days solid but once the user has clicked on the value they want i want to store that chosen value in the lookup field or another one in the table.
When i click nothing happens..
please can anyone help me while I go a make a cup of tea and wonder why i dont have a life?
Last edited by funkkube; 10-15-04 at 09:06.
Reason: more detial in title