G
Guest
I have a list box on a form that is getting its list data from a table. The
only purpose of the table is to fill this list box. It should only have one
each of ENGA, ENGB, ENGC, etc., in it. Yet, every time I run the form that
allows the user to select one of these choices that provides the parameter
info for the query, it will add another line of whatever item is chosen into
the table that supplies the list box. For example, if a user wants to run
the query to see all courses that fulfill ENGC requirements, the form pops up
with the list box. They select ENGC in the list box & a query runs that
provides that information. But when I go back into the table that supplies
the items for the list box, there are now two ENGC entries. What am I doing
wrong? This table should never have more than one of each item.
only purpose of the table is to fill this list box. It should only have one
each of ENGA, ENGB, ENGC, etc., in it. Yet, every time I run the form that
allows the user to select one of these choices that provides the parameter
info for the query, it will add another line of whatever item is chosen into
the table that supplies the list box. For example, if a user wants to run
the query to see all courses that fulfill ENGC requirements, the form pops up
with the list box. They select ENGC in the list box & a query runs that
provides that information. But when I go back into the table that supplies
the items for the list box, there are now two ENGC entries. What am I doing
wrong? This table should never have more than one of each item.