Parameter Query Using Combo Box
Did you make a selection in the Combo before running the query?
If you want all records whereby you do not make a selection try using this --
SELECT TrackingID, DocumentNumber,DocumentType, RequestDate,DueDate,
ProgramID, AssignedTo, Author, StatusDate,Subject,Notes
FROM tblDocTracking
WHERE tblDocTracking.ProgramID Like
IIF([forms]![frmProgramSelect]![ProgramID] Is Null, "*",
[forms]![frmProgramSelect]![ProgramID]);
--
Build a little, test a little.
"PleaseHelpMe" wrote:
There are no recorsd being returned when i run my parameter query.
SELECT TrackingID, DocumentNumber,DocumentType, RequestDate,DueDate,
ProgramID, AssignedTo, Author, StatusDate,Subject,Notes
FROM tblDocTracking
WHERE (((tblDocTracking.ProgramID)=[forms]![frmProgramSelect]![ProgramID]));
I have frmProgramSelect open.
I am not sure what i am doing wrong. Can you help?
|