Adding 'All' to a cbo selection

[Junior]

Using a [cboPosition] to limit selections in [cboApplicant]
[cboPosition] Rowsource is:
SELECT TlkpAppPosition.PosID, TlkpAppPosition.PosDesc
FROM TlkpAppPosition;
Want to add "All" as the default selection in [cboPosition] to allow all
records to appear in cboApplicant.

[cboApplicant Rowsource is:
SELECT [qfrmAppPick].[AppID], [qfrmAppPick].[Name], [qfrmAppPick].[SSN],
[qfrmAppPick].[PosID], [qfrmAppPick].[Date] FROM qfrmAppPick ORDER BY
[qfrmAppPick].[Name];

[qfrmAppPick] is a parameter query:
SELECT TblApp.SSN, [lname] & ", " & [fname] AS Name, TlkpAppPosition.PosDesc
AS [Position], TblApp.AppID, TblApp.ApplicationDate AS [Date],
TblApp.AppPosition AS PosID
FROM TblAppMstr INNER JOIN (TblApp LEFT JOIN TlkpAppPosition ON
TblApp.AppPosition = TlkpAppPosition.PosID) ON TblAppMstr.SSN = TblApp.SSN
WHERE (((TblApp.AppPosition)=[forms]![frmAppEnter].[cboPosition]));

How can i add "All" as a selection in [cboPosition] so that all records will
appear in [cboApplicant]

Thanks in advance for assistance

 

[Douglas J. Steele]

See http://www.mvps.org/access/forms/frm0043.htm at "The Access Web" for how
to add All to the combo.

Change your parameter query to

WHERE TblApp.AppPosition=[forms]![frmAppEnter].[cboPosition] OR
[forms]![frmAppEnter].[cboPosition] = "All"

 

[Junior]

Thanks

See http://www.mvps.org/access/forms/frm0043.htm at "The Access Web" for
how to add All to the combo.

Change your parameter query to

WHERE TblApp.AppPosition=[forms]![frmAppEnter].[cboPosition] OR
[forms]![frmAppEnter].[cboPosition] = "All"


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Using a [cboPosition] to limit selections in [cboApplicant]
[cboPosition] Rowsource is:
SELECT TlkpAppPosition.PosID, TlkpAppPosition.PosDesc
FROM TlkpAppPosition;
Want to add "All" as the default selection in [cboPosition] to allow all
records to appear in cboApplicant.

[cboApplicant Rowsource is:
SELECT [qfrmAppPick].[AppID], [qfrmAppPick].[Name], [qfrmAppPick].[SSN],
[qfrmAppPick].[PosID], [qfrmAppPick].[Date] FROM qfrmAppPick ORDER BY
[qfrmAppPick].[Name];

[qfrmAppPick] is a parameter query:
SELECT TblApp.SSN, [lname] & ", " & [fname] AS Name,
TlkpAppPosition.PosDesc AS [Position], TblApp.AppID,
TblApp.ApplicationDate AS [Date], TblApp.AppPosition AS PosID
FROM TblAppMstr INNER JOIN (TblApp LEFT JOIN TlkpAppPosition ON
TblApp.AppPosition = TlkpAppPosition.PosID) ON TblAppMstr.SSN =
TblApp.SSN
WHERE (((TblApp.AppPosition)=[forms]![frmAppEnter].[cboPosition]));

How can i add "All" as a selection in [cboPosition] so that all records
will appear in [cboApplicant]

Thanks in advance for assistance