I use the formmanager and have two modes (Search and Edit) to access a DB.
When I change the mode I just want to change the BoundColumn, DataField, ListField, Recordset and RowSource Properties of the Listbox and set a new SQL (only to select another field) in the according Recordset instead of inserting an extra Listbox and Recordset. But this doesn't work. (sorry, I don't know the error message at the moment)
Maybe this is the wrong way to solve this problem ...
Thanks,
Gregor
When I change the mode I just want to change the BoundColumn, DataField, ListField, Recordset and RowSource Properties of the Listbox and set a new SQL (only to select another field) in the according Recordset instead of inserting an extra Listbox and Recordset. But this doesn't work. (sorry, I don't know the error message at the moment)
Maybe this is the wrong way to solve this problem ...
Thanks,
Gregor