Parameter Query Using Combo Box
I would like to point out that this works if ProgramID is never null. Also
since you are using LIKE the assumption is that ProgramID is a text field,
although Access will automatically convert the value in the field to a string
in most cases.
John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
KARL DEWEY wrote:
Another way (copied from John Spencer post) --
SELECT TrackingID, DocumentNumber,DocumentType, RequestDate,DueDate,
ProgramID, AssignedTo, Author, StatusDate,Subject,Notes
FROM tblDocTracking
WHERE tblDocTracking.ProgramID Like
Nz([forms]![frmProgramSelect]![ProgramID], "*");
|