Using a combobox to filter between entries? 1

[fiel]

I have single table that will hold the following information for ProgrammingCodes: author, version, description, hyper-link to file. I have a combo box for each one set so I can filter through each entry based on any one category. The only thing is I linked my combo boxes to my only table where my data is stored. As a result, when I search based on say authors for example, the same name will appear multiple times for each record I have based on a particular author; this occurs for all other categories as well. Is there so that the combo box will not show the same category mulitple times (example: so that that an author's name only appears once)?

 

[randy700]

Have you tried using the keyword DISTINCT?


Randy

 

[fiel]

Thanks, actually I stumbled across this tutorial on SQL for beginners and found that I needed to do a GROUP BY Function.

http://www.vbexplorer.com/VBExplorer/vb_feature/june2000/SQL_for_Beginners.asp

 

[PHV]

I needed to do a GROUP BY Function
Do you use any aggregate function ?

 

[fiel]

Aggregate?

 

[PHV]

Aggregate functions: Sum, Count, Avg, Min, Max, ...

 

[fiel]

Nope, I put the GROUP BY statement in my data properties for my combo box. Everything is working as I need it, but when I delete or add new information, it won't immediately show up in the combo box (unless I reopen the form in some cases). Is there any way to keep the combo boxes always updating to avoid this?

 

[PHV]

Nope
So, you don't need a GROUP BY clause but simply the DISTINCT predicate.

keep the combo boxes always updating
You may try this in the Current event procedure of the form:
Me![name of combo].RowSource = Me![name of combo].RowSource

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[fiel]

When I tried out that code in the Form's Current event Procedure, it worked at some times but all the time. Would there be a problem in this if my combo boxes were in a main form and the data displayed and entered were shown below in a subform?

 

[PHV]

So, in the Current event procedure of the subform:
Forms![name of mainform]![name of combo].RowSource = Forms![name of mainform]![name of combo].RowSource

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886