Parameter Query Using Combo Box

[PleaseHelpMe]

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?

 

[vanderghast]

Be sure the control ProgramID is out of focus, to be sure that the value you
keyed in has been "updated". If the control is not updated (committed),
its last committed value, probably a null, will be used by the query.


Vanderghast, Access MVP

 

[Jeff Boyce]

Any chance that the ?combobox field in your expression ([ProgramID] doesn't
actually hold the ProgramID field?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[KARL DEWEY]

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]);

 

[KARL DEWEY]

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], "*");

 

[John Spencer]

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

 

[PleaseHelpMe]

I am so embarassed! I didnt actually name the combo box ProgramID! I renamed
and my original coding worked.

Thanks all and sorry for wasting your time!

Any chance that the ?combobox field in your expression ([ProgramID] doesn't
actually hold the ProgramID field?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

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?

.