All in a combo box

[mpm32]

I have a form that has a list box. I have query that populates the items in the list box. I have made a combo box on another form where the user picks the frequency that they want to view. They then click the Open form button and it will pull up the form with the list box filtered with their choice.

I made a Union Query to add all to the list in the combo box. The combo box list gets populated by another query.

This is the SQL in the union query.

SELECT[List:FrequencyQuery].Frequency, [List:FrequencyQuery].Frequency FROM [List:FrequencyQuery];  UNION SELECT "*", "<All>" as  FROM [List:FrequencyQuery];

When I select the <All> no records come up. It also doesn't pull up records with the blank choice, or the "-" choice. I will pull up the other choices.

In my combo box I have set the column count prop to 2, the bound column to 1.

Any idea what I'm doing wrong? I even tried making a text box that will fill with the combo box choice and referencing that in the query that pulls up the list box form but that didn't work either.

Thanks,

Mark

 

[mpm32]

The as after "<All>" is not there that was an error it does read;

SELECT[List:FrequencyQuery].Frequency, [List:FrequencyQuery].Frequency FROM [List:FrequencyQuery];  UNION SELECT "*", "<All>" FROM [List:FrequencyQuery];

 

[PHV]

What is the SQL code of the RowSource property of your filtered ListBox ?

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

 

[mpm32]

It is;

SELECT MasterRecordstbl.ID, MasterRecordstbl.Entity, MasterRecordstbl.Name, MasterRecordstbl.State AS St, MasterRecordstbl.Rep, MasterRecordstbl.TaxType AS [Tax Type], Frequencytbl.Frequency AS Freq, Frequencytbl.DueDate AS Due
FROM MasterRecordstbl INNER JOIN Frequencytbl ON MasterRecordstbl.ID = Frequencytbl.TaxID
WHERE (((Frequencytbl.Frequency)=[Forms]![ActionsForm]![FreqCombo]));

 

[PHV]

The combo's rowsource:

SELECT Frequency, Frequency FROM [List:FrequencyQuery]
UNION SELECT '*', '<All>' FROM [List:FrequencyQuery]

The listbox's rowsource:

SELECT M.ID, M.Entity, M.Name, M.State AS St, M.Rep, M.TaxType AS [Tax Type], F.Frequency AS Freq, F.DueDate AS Due
FROM MasterRecordstbl M
INNER JOIN Frequencytbl F ON M.ID = F.TaxID
WHERE F.Frequency = [Forms]![ActionsForm]![FreqCombo] OR [Forms]![ActionsForm]![FreqCombo] = '*'

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

 

[mpm32]

Excellent that works great for the all selection.

You used some abbreviations on the listbox SQL, can you explain how this works?

Also, this isn't imperative to my project but when the "-" or the blank is selected, I do not get any results in the listbox. Why is that?

Thanks for your help today. (twice)!

Mark