Hi Experts - I'm sure this must be simple but I'm just missing the solution ....
I have a combobox bound to a column (fTitle) that shows the title for a contact (i.e. Mr / Mrs / Miss etc .....). This combobox uses a seperate datasource table to pick up the available titles. That seems to work fine but I want to restrict the combobox input to only those values in the datasource column. At the moment although the dropdown shows the correct list, it will allow me to overwrite with anything I choose.
The database is MS Access and in the appropriate table fTitle is designed as a lookup field linked to the titles table. In Access this restricts the user to only inputing values from the titles table - but when updated from my VS app it allows me to update to anything.
Your help would be much appreciated.