ActiveX Control Properties

When developing an ActiveX control, I want to create a property which can be set at design-time using a dropdown list (in the property list window).
The list should be made up from a recordset produced from a SQL statement such as "select ValidationName from ValidationTable", maybe from a stored procedure.

How do I do this and what 'type' must I set the property as?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Don't think this is possible in VB. VB only supports static lists.
The way around it, btw, is to use property pages and expose the properties only through them. And the way to do *that* is to make them Friends.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
kwlbAuthor Commented:
Does VB not do something similar though when setting the datasource propetry of a bound control to the ADO sources on a form??
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

No. The controls may be VB controls, but they were not written using VB.... that's the difference.
caraf_g is correct... There is no way to do this in VB. The property page is a good workaround.

The reason a VB program can't to this is because the box that shows up in the Properties window is really a textbox and when you add your ActiveX control to a form at development time, the control is actually in "run-time" even though you haven't run your program yet...

Since the control is in run-time, it can't set the MultiLine property of the property window (for example, like a listbox list property) because the MultiLine property can only be set at development time...

I know this is confusing, but that's the way it is...

kwlbAuthor Commented:
Thankyou very much.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.