I have fields in an Access 2000 database where usable values have been set using the row source entry in the design view of Access. Is there any way to pull those available values so i can stick them in a combobox or something? I'm using ado.
Printable View
I have fields in an Access 2000 database where usable values have been set using the row source entry in the design view of Access. Is there any way to pull those available values so i can stick them in a combobox or something? I'm using ado.
I've tried this one myself and there's no way of doing with ADO and Jet. There are only five properties available for a Field and none of them are relevant. You might have to populate a table with the available values and use that to populate the combobox. This same table could be used for all the different sets of values you might need, just use a different key to identify the ones you want for a particular box.