object descriptions

[bpaquette]

So I have a form that lists all my queries, and you can pop one open with a click. My problem is that I want to display descriptions for each query. I imagine this is done by displaying the description field of that object somewhere on the form.

i'm using an msysobjects query to gather the filenames and whatnot for the list, can that somehow be utilized?

is the answer right in front of me?

BP

 

[bpaquette]

sorry for the timespaz of this post, but i've been researching this and still can't find anything. anyone have any ideas?

 

[Pat Hartman]

No, you can't get the description from the mSysObjects table. You would need to read the querydefs collection.

 

[bpaquette]

er just in case anyone reads this thread wanting to do the same thing: I just set up a table/query with descriptions and worked some row source magic with a list box.