Data Filter Question

[FoeHunter]

I’m not sure if this is even possible, but I want to say it is. I am building a large database for all of the various shops in our area to track/verify their compliance with the self inspection guidelines. All of the various checklists are contained in the same table.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
On the form “QuestionInterface”, I have a drop down bar called “Category” . Is there a way to have Access look at all of the values in the “SourceDocument” field of the “QuestionMaster” table and display all of the values, without repeating them? For example, I have 3 checklists with 250 questions each, I only want 3 values displayed on the drop down menu, rather than 750.
<o> </o>
Yes, I could go through and pre-define values, but the checklists change often and if there was a way to automate it I think that is the method that should be used.
<o> </o>
As always, thanks in advance.
-Foe

 

[xenou]

The Row Source of the Combo Box can be set to a query:

SELECT DISTINCT QuestionMaster.SourceDocument FROM QuestionMaster;

 

[FoeHunter]

This appears to work, I have two blank lines showing up on the dropdown menu, and I have 2 seperate checklists loaded to test, but nothing is being displayed. so I don't know which one is being selected.

 

[xenou]

Check the column width of the combobox - set it to a small width at first (.25)
Sometimes you just cannot see the contents.

 

[FoeHunter]

That was the problem, it was set to 0"

Thanks again