From Post #7:
Originally Posted by
ssanfu
Also found another error. In "tblLanguages", "Language" is a reserved word.
Change it to something like "LanguageName" or "txtLanguage".
In tblBooks, the field "txtLanguage" MUST be a type Number-Long because it should be a foreign key to the PK field in "tblLanguages".
For the Languages combo box, look at my demo dB. Look at the combo box row source.
It should be
Code:
SELECT tblLanguages.Languages_ID, tblLanguages.LanguageName FROM tblLanguages ORDER BY tblLanguages.LanguageName;
Why do you have tblBooks.Languages"????????