
Signature
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
> Thanks for the valuable help I have got in this forum so far.
> Another, and probably simple question:
[quoted text clipped - 5 lines]
> adjust for my purpose. Thanks for any help.
> Niels
Thanks Allen. Your advice is always appreciated. However, I still have some
problems, but let me post the query that the form is based upon:
SELECT qryParam3.ProjectID, qryParam3.Projectsymbol, qryParam3.Title,
qryParam3.Region, qryParam3.Status, qryParam3.StatusDate, qryParam3.Budget,
qryParam3.SubjectName
FROM qryParam3
WHERE (((qryParam3.Region)=[Forms]![frmParam3Test]![cboRegion]) AND
((qryParam3.Status)=[Forms]![frmParam3Test]![cboStatus]) AND
((qryParam3.SubjectName)=[Forms]![frmParam3Test]![cboSubject]));
The report called by the print/print preview button on the form comes out
fine except when one or more of the choices in the combos are **ALL**, then
the report returns blank. The **ALL** is added to to each combo (here is one
example):
SELECT tblSTATUS.Status FROM tblSTATUS UNION SELECT "**ALL**" as Bogus from
tblstatus
ORDER BY tblSTATUS.Status;
Niels
> The list box will have a RowSource property that defines the 5 columns and
> the records. You can create a query that selects the same fields and
[quoted text clipped - 9 lines]
> > adjust for my purpose. Thanks for any help.
> > Niels
NielsE - 30 Nov 2005 23:02 GMT
I think I figured it out by adding ..OR criteria="**ALL**
> Thanks Allen. Your advice is always appreciated. However, I still have some
> problems, but let me post the query that the form is based upon:
[quoted text clipped - 32 lines]
> > > adjust for my purpose. Thanks for any help.
> > > Niels