Hi,
I'm trying to replicate an app I'd written in Access where a number of fields used bound comboboxes that would display the fields from the current record, but would give the option via the dropdown of a fixed list of items.
I have been able to bind a combobox to a datasource (SQL), but the dropdown only lists items from the field shown, and I cannot see how to tie a set list (for example a query) to the dropdown.
Any ideas anyone?
I'm trying to replicate an app I'd written in Access where a number of fields used bound comboboxes that would display the fields from the current record, but would give the option via the dropdown of a fixed list of items.
I have been able to bind a combobox to a datasource (SQL), but the dropdown only lists items from the field shown, and I cannot see how to tie a set list (for example a query) to the dropdown.
Any ideas anyone?
