CFL -> Dropdown?
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.
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.