I have a combp box that looks up Client Names..
On change it chages the Record Source values in the form of a sql staemnet to bring up relevent records on a subform..
It brings them up ok so fantastic..
I have a combo box on the subform that looks up relevent answers to the question that the use can choose from..
This is the code..
Dim tempclientid As Integer
Dim tempQuestionID As Integer
Dim tempsql As String
tempclientid = ClientID
tempQuestionID = questionsID
tempsql = "SELECT [Export StockQA].AnswerValue FROM [Export StockQA] WHERE (([Export StockQA].ClientID)=" & tempclientid & ") AND (([Export StockQA].QuestionsID)=" & tempQuestionID & ");"
[Combo8].RowSource = tempsql
This subform works 100% when its not a subform..
When it becomes a subform and I click in the combobox to get the relevent answers it comes up wiht the error...
Can anyone help?