🚀 go-pugleaf

Vladimir wrote:

>> Row Source is *NOT* a property of a Field.  It's a property
>> of the ComboBox on the Form in Access.
> 
> Then how can I get those sort of properties?

I'm not sure you can with ADO.  If you use Access COM, you might
be able to, but it may require the form be open (the Access COM
includes a Forms collection, which would contain the Form in
question, but I'm not sure you can access it unless the Form is
opened).

>> Are you saying you get "Above" in that case and "1" if you issue
>> an SQL statement through VC++?  That's.... impossible.  Something
>> else is going on.  Are you sure the Query Designer isn't linking
>> in a table or doing some sort of lookup?
> 
> It is possible. You can create your own table in Access with one
> field having lookup with following properties:
> 
> Display control = Combo Box
> Row ource type = Value list
> Row source = 1;"qwe";2;"asd";3;"zxc"
> Bound column = 1
> Column count = 2
> Column heads = No
> Column widths = 0cm;4cm
> List rows = 8
> List width = 4cm
> Limit to list = Yes

Yes, this is exactly what I was talking about.  The Access table
has a control defined in it.  I'm fairly certain you can't access
this via ADO, but you might via Access COM.

> Then fill table with data and enter MANUALLY in Query Designer
> (View / SQL mode) this text: SELECT <field> FROM <table> - and
> you will get strings.

Yes, I see what you mean, now.  I'm leaving for the day and might
not be back until Monday, but if you are still having trouble then,
I'll see if I can provide some areas to explore.

-- 
|_ CJSonnack <Chris@Sonnack.com> _____________| How's my programming? |
|_ http://www.Sonnack.com/ ___________________| Call: 1-800-DEV-NULL  |
|_____________________________________________|_______________________|