combobox does not open. why?

[Nifrabar]

On a form I do have a combobox with parametrized view as contolsource and a lookuptable as rowsource.
That does what is expected.
Now I do remove the lookuptable and use instead a view with same fields as lookuptable.
Now there is no drilldowninfo in the combobox.
Any idea why?

TIA
-Bart

 

[Imaginecorp]

If the view used for lookup is a parametrized view, maybe no records matched your criteria. do a "set step on" to see if there are records, also have you set the recordsourcetype to 6-fields...Also when & where are you setting the rowsource?

 

[Imaginecorp]

recordsourcetype = rowsourcetype

 

[Nifrabar]

Imagincorp:
This is real weird!
I have set the rowsource in the usual way, indeed, using recordsource being 'fields'. (Not by code.)
The controlsource is a parametrized view whereas the rowsource is normal view.
That combo seems not to be populated.
Exactly same code on a testform does work!
Than in stead of that view for rowsource the 'basetable' makes it work!
-Bart

 

[Imaginecorp]

Is the view in the Dataenvironment? and if so is the NoDataOnLoad for the view set to .F.

 

[Imaginecorp]

Oh hold on, when you say
"That combo seems not to be populated.", do you mean there is No value being displayed in the combobox, Or there are No records in the dropdown list?

All of my suggestions above address the latter...
For the first (nothing displayed) one reason could be its just that the view (drop down list) does not contain the value saved in the control source

 

[Nifrabar]

All views are in DE, nodataonload is set to .f.
And for sure the controlsource contains value which are in lookup-view.

As said earlier: the weird thing is that if I replace same combobox just bu ^C ^V to another (test) form, than the behaviour is as expected.

 

[Imaginecorp]

Strange...The only thing I got left is check the DE's

AutoOpenTabels = .T. - Default

 

[Nifrabar]

AutoOpenTables = .T.
I can't see any reason why the combobox behaviour is differnt on data form and testform.
For now I solved this by replacing the view with table on which view was based.
Imaginecorp, thanks for your efforts on this thread.
KR
-Bart

 

[Imaginecorp]

Sorry, could not be of help...