Strange Issue in Lookup combbox

[Fahad]

Dear;

I have a database to organize our EA media. i have one table to list
microsoft products named as tblProductslist. this table consist of 2 fields
(primary [Autonumber] & 2nd one is the product's name).
here is a sample of this table:
ProductID ProductName
1 office 2007 Enterprise
2 office 2007 Profesional Plus
3 ofice 2003 Pro
4 office 2003 standard
5 Exchange Server
6 SQL Server
..
etc

I have another table to enter the media info which is the main table in my
DB named it as tblMediaInfo. one of the fields in this table is the
ProductName which is a lookup combobox to the tblProductslist table.
when I click on this field, I get the list of the products and choose one of
the list.
actually it works fine for most of the products i chosen but when I choose
from the list the following product (Office 2007 Professional Plus), it
choose all subsequent products in the table start with office and put it as a
value in this field.

there is a relation between the 2 tables (one-to-many), productID field in
the tblProductslist table and productID in the tblMediaInfo table.

any idea or help is appreciated.