DBList Rowsource problem 2

[Rechmali]

Hi, I wonder if someone might be able to give me a nudge in the right direction please.

I am trying to populate a dblist box using the following bit of code :

Set ScriptRS = objcomm.Execute("get_PrescriptionDetailsListBox", pr_Parameter, adCmdStoredProc)
       
With dblScript
    
    Set .RowSource = ScriptRS
        .ListField = "Script"
        .BoundColumn = "DetailID"
End With

Hoever when it gets to the Set .RowSource line, it fails saying:
Run-time error 91
Object variable or With block variable not set.


I don't understand what is going wrong as I have copied the code from another part of the same database which does work , only changing the ScriptRS name.

Data is being retrieved into the recordset, I have established that much!

Please help while I still have hair.

Cheers
Chris

 

[JCruz063]

Chris,
Step through your code stop it at the line after this one:

Set ScriptRS = objcomm.Execute(...)

Then, using the Watch window, inspect the ScriptRS variable. It might be that objcomm.Execute(...) is returning nothing.

JC

_________________________________________________
To get the best response to a question, read faq222-2244!

 

[Rechmali]

Thanks for your quick response.

It is returning a value.

If I put in another line of code after the set, I can see the info that I want...

Darn coding!

 

[JCruz063]

Chris,
How about dblScript? Is that properly initialized? There's really not much more we can look at. With the error: "Object variable or With block variable not set", you really don't have many choices. Inspect every single bit of code around that line and check what hasn't been initialized.

JC

_________________________________________________
To get the best response to a question, read faq222-2244!

 

[sdraper]

have you tried simply
.RowSource = ScriptRS
rather than
Set .RowSource = ScriptRS
I don't think the set keyword is necessary for this control

Sam

 

[Rechmali]

Hi Guys,

Thank you both for your help.

Turns out that I had changed the component list and when I made sure I had the dblist with the yellow on the icon, I was able to make it work.

BIG LEARNING CURVE at the moment!

Chris