Querydef question

[Kizzi]

Hi

I was hoping someone could lead in the right direction with this problem I'm having.

I have two combo boxes one is populated when the form is loaded and the other is populated dependant on the selection made in the 1st one. This works when I run it in code but as soon as I make an executable it won't populate the 2nd box it just crashes.

Here's the code below:

Set DataB = OpenDatabase(App.Path & "\Database\Test.mdb")

Set QD = DataB.QueryDefs("qrySubCat")
QD.Parameters("[CatID]") = mCatID
Set rs2 = QD.OpenRecordset(dbOpenDynaset)

Could anyone tell me why this may be occuring

Thanks!!

[Sastraxi]

This isn't the place for questions -- "Once you have your project together, come here to discuss..."

That's basically what the definition says and I stand by it. That's why the threads in here are so huge.

[Kizzi]

Thanks for your advise.................