Hi
I created a combo box in the form to select ALL record and export to excel (I created a button). I researched a lot in the web but still can't work.
What I have add the following in the Row Source of the Property sheet of the unbound combo box.
Select “ALL” FROM qryClient UNION Select clt.Field1 FROM qryClient GROUP BY clt.Field1
It prompts to ask to Enter the Parameter.
Please help how to fix.