View Single Post
  #7  
Old June 2nd, 2010, 11:09 PM posted to microsoft.public.access.queries
pleasehelpme
external usenet poster
 
Posts: 4
Default Parameter Query Using Combo Box

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!

"Jeff Boyce" wrote:

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.

"PleaseHelpMe" wrote in message
...
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?



.