CFL -> Dropdown?

Tim.Rainey

Is there a way to have a true dropdown or pulldown based on a CFL or query? Or even better, I fill in the first few letters of what I want the value to be and it auto completes my entry?

Just trying to enhance the experience for the users.

Anders Olsson

Hello Tom,

Kind of, yes. But not as dynamic as a CFL. In the FormLoad event

1. Create a ComboBox object and add it to the form

2. Populate its ValidValues property. This can be done using a query indirectly. Iterate though the DataReader and for each row call ComboBox.ValidValues.Add().

If you need to change ValidValues based on form data (i.e. in each FormDataLoad) would not be a good idea because it would be slow. CFLs have better performance.

"Or even better, I fill in the first few letters of what I want the value to be and it auto completes my entry?"

- Not possible.

Regards

Anders