Combo Box on form is only showing form field values not linked table values
I am having a problem with a combo box on a form. I should be able to key in a number and have it populate if it is in the table. Instead I get an error saying" text entered is not a value in list." It only shows record values previously entered in the form for that field, instead of the values on the table it is linked to.
The limit to list is set to yes. I have gone back to the main table and relinked the field to the source table in lookup wizard. This has not helped. The relationships on the form are also duplicating upon closure. It shows TableName, TableName1, TableName2, etc. It shows the correct link from the main table to the other table based on the key, but I am wondering if this has something to do with the problem?
Any help would be greatly appreciated!!