Michel..


IMO, the best solution is to use a cursor as it scales better. If you want to add a value manually, you can simply append a record to the cursor and if necessary, add a flag to indicate that the new manually added value should be written to the backend.




>I am wondering what is the best approach to take when we have a listbox of type 1 - Value where we enter our own values in RowSourceType property. It's not like a listbox of type 3 - SQL where we can bound the control source to field on BoundColumn 2. Basically, what is the best approach to bound the control source when entering the values manually at the form designer level?