Combobox based on a Query
I am using Access XP (2000 format) and have built a database to track speaking engagements and topics covered. I have a form with a combobox to select a record (which is connected to a report and produces a list of topics I have spoken on in the particular organization) to run a report. The combobox gets the information form a query and I am having two problems:
1. I see the list of organizations in the combobox and each organization is repeated the number of times I have spoken at the organization.
2. The combobox does not allow me to select a record from the list.
Can any one help me with this problem? Thanks!
Juan
[653 byte] By [
hamburg18w] at [2007-11-11 7:35:49]
# 1 Re: Combobox based on a Query
The data source for your ComboBox should be a lookup table that only contains unique values. It sounds like the query you're using is based upon a table or tables that contains particular organizations in more than one row. That would account for the duplicates.
Could you post your query so we can take a look at it?
