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

0

Comments

0 comments

Please sign in to leave a comment.

Didn't find what you were looking for?

New post