Form

[jakobt]

Hi,
I have created a form taking in Data from a query.

On the form I have created a combo box. The selected value is used in an criteria of the query.
The criteria in the query is:
[Forms].[frmMyPortfolio]![cbodep]

How can I ensure that all values in query are generated, if their is no selection in the combos.

 

[GohDiamond]

Try this in the query:
[Forms].[frmMyPortfolio]![cbodep] Or Like "*"
It should aggregate ALL records if nothing is selected in the cboBox
Cheers!
Goh