Hello. I have an Access 2000 problem.
I have successfully imported a database from SideKick into Access and all 750 records appear to have been imported correctly. I have set up a form using the wizard and it works fine as well. Now I would like to refine it by making one of the fields a combo box with a list of defined values to choose from. So...I created a separate table with the values I wanted, matching the values that already exist in the main table for that field. However, now when I open the form, every record gives me a prompt that 'the value you entered isn't valid for this field' even though the word that appears is one of the choices listed. Clearly I have done something wrong but I can't get my mind around what it is.
Any help would be appreciated.
The field in the main table is called Category and there are three categories to choose from: Classical, Popular or Contemporary.
Each existing record has one of those choices already.
I want to do this so that when future records are added, the choice is limited to the options in the new table.
Thanks for your help.
theolddog
I have successfully imported a database from SideKick into Access and all 750 records appear to have been imported correctly. I have set up a form using the wizard and it works fine as well. Now I would like to refine it by making one of the fields a combo box with a list of defined values to choose from. So...I created a separate table with the values I wanted, matching the values that already exist in the main table for that field. However, now when I open the form, every record gives me a prompt that 'the value you entered isn't valid for this field' even though the word that appears is one of the choices listed. Clearly I have done something wrong but I can't get my mind around what it is.
Any help would be appreciated.
The field in the main table is called Category and there are three categories to choose from: Classical, Popular or Contemporary.
Each existing record has one of those choices already.
I want to do this so that when future records are added, the choice is limited to the options in the new table.
Thanks for your help.
theolddog