Prev: How to use txtboxes and Combo boxes in a form
Next: Retrieve all record if check box = 0 (Not checked)
From: John Spencer on 28 May 2010 11:37
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], "*");
>
From: PleaseHelpMe on 2 Jun 2010 18:09
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" <PleaseHelpMe(a)discussions.microsoft.com> wrote in message
> news:8CE604CD-3C0F-4DA4-B341-05246BC8CA75(a)microsoft.com...
> > 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?
>
>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: How to use txtboxes and Combo boxes in a form
Next: Retrieve all record if check box = 0 (Not checked)