Compile Error : Variable Not Defined

[redskycorp]

Hi guys ! I am new here, i just wanna ask. I know the solution for this problem is simple but i just cannot figure it out......I get the error at the italized area.

Option Explicit
 
Dim pdbQue As DAO.Database
Dim mrstQue As DAO.Recordset
Dim querQue As DAO.Recordset
 
Private Sub Form_Load()
Label7 = 1
Set pdbQue = OpenDatabase(App.Path & "\Test Editor.mdb")
Set mrstQue = pdbQue.OpenRecordset("SELECT * FROM Quest ORDER BY QuestionId")
Set querQue = pdbQue.OpenRecordset("Quest Query", pdbQueOpenDynaset)
Main.Que_No
Main.Set_No
Label9.Caption = Main.topic
Command5.Enabled = False
End Sub
 

[JKing]

Try changing this:

Set querQue = pdbQue.OpenRecordset("Quest Query", pdbQueOpenDynaset)
 

To this:

Set querQue = pdbQue.OpenRecordset("Quest Query", dbOpenDynaset)
 

[redskycorp]

I tried that it does not work.....It still says invalid operation and highlights the whole line.....

Set querQue = pdbQue.OpenRecordset("Quest Query", dbOpenDynaset)

Maybe it has something to do with reference ?..... :(

Does anyone know what the problem could be ?....

[JKing]

So you're getting an invalid operation as opposed to an undefined variable error now?

Could you post the sql for "Quest Query"