Help! with duplications

[Guest]

I have a report on equipment information that comes up by selecting the
equipment name from a drop down list on a form. The form then has a button
that leads to the report on whichever equipment name selected. It seems that
everytime I select an equipment name, everything works fine, except that name
is re-added to the drop down list and the equipment name table and query. I
have NO idea why this duplicaiton is happening or how to stop it! If I view
the report 5 times on the same piece of equipment, I will have 5 or more of
the same piece of equipment in the table,
Please help!
-Thanks

 

[Guest]

Hi Nikki,

Have a look at the properties for the drop down box and see where it gets
the data from. Ideally it should be a particular field in a table, or the
result of a query. The query should then be looking for unique records only,
and the table should have that field identified as not accepting duplicates.

Hope this helps

Regards

DavidC