This is really annonying me. I have an access DB that I am accessing through VB. I have a DBcombo DBGrid and Data Control.
I have about 7 forms. Main form calls the other forms where I am running a query. On the first 3 forms this works fine:
Private Sub DBCombo1_Click(Area As Integer)
Let Me.Data1.RecordSource = "SELECT * FROM [STUDENT QUERY] WHERE [student id]= '" & _
Me!DBCombo1.Text & "'"
Even though It appears that I have the exact same code and properties for the controls, On all the other forms when I open the dbcombo or when the form loads, I get this message
Runtime Error 438
Object does not support this property or method
It occurs with the Data1.Refresh.
If I remove Data1.refresh I don't get errors, but of course the dbgrid is not bound to my dbcombo.
What am I doing wrong?