I'm having trouble with the multiple criteria in this code. It isn't
returning the record I know is there.

Me.PWIDTH6.RowSource = "Select distinct parts.lheight " & _
"FROM parts " & _
"WHERE parts.ItemDesc = '" & descrip.Value & "' " & _
"AND parts.pwidth = '" & Text2.Value & "' " & _
"ORDER BY parts.lheight;"

Can anyone help me?

Thanks in advance,

Bonnie

Is the field "pwidth" type is numeric?
If so you need to drop the single quote, that you use only for text fields

Me.PWIDTH6.RowSource = "Select distinct parts.lheight " & _
"FROM parts " & _
" WHERE parts.ItemDesc = '" & descrip.Value & "' " & _
" AND parts.pwidth = " & Text2.Value & " " & _
" ORDER BY parts.lheight;"

--
Good Luck
BS"D


"Bonnie" wrote:

> I'm having trouble with the multiple criteria in this code. It isn't
> returning the record I know is there.
>
> Me.PWIDTH6.RowSource = "Select distinct parts.lheight " & _
> "FROM parts " & _
> "WHERE parts.ItemDesc = '" & descrip.Value & "' " & _
> "AND parts.pwidth = '" & Text2.Value & "' " & _
> "ORDER BY parts.lheight;"
>
> Can anyone help me?
>
> Thanks in advance,
>
> Bonnie

Thanks Ofer - you have helped me before also. I appreciate your taking the
time. It is numeric and I'm sure that's it.

Thanks again.

Bonnie

"Ofer Cohen" wrote:

> Is the field "pwidth" type is numeric?
> If so you need to drop the single quote, that you use only for text fields
>
> Me.PWIDTH6.RowSource = "Select distinct parts.lheight " & _
> "FROM parts " & _
> " WHERE parts.ItemDesc = '" & descrip.Value & "' " & _
> " AND parts.pwidth = " & Text2.Value & " " & _
> " ORDER BY parts.lheight;"
>
> --
> Good Luck
> BS"D
>
>
> "Bonnie" wrote:
>
> > I'm having trouble with the multiple criteria in this code. It isn't
> > returning the record I know is there.
> >
> > Me.PWIDTH6.RowSource = "Select distinct parts.lheight " & _
> > "FROM parts " & _
> > "WHERE parts.ItemDesc = '" & descrip.Value & "' " & _
> > "AND parts.pwidth = '" & Text2.Value & "' " & _
> > "ORDER BY parts.lheight;"
> >
> > Can anyone help me?
> >
> > Thanks in advance,
> >
> > Bonnie

Hi Ofer,

That wasn't the problem, I tried it both ways and get the same behaviour.
Any other ideas?

Thanks,

Bonnie

"Ofer Cohen" wrote:

> Is the field "pwidth" type is numeric?
> If so you need to drop the single quote, that you use only for text fields
>
> Me.PWIDTH6.RowSource = "Select distinct parts.lheight " & _
> "FROM parts " & _
> " WHERE parts.ItemDesc = '" & descrip.Value & "' " & _
> " AND parts.pwidth = " & Text2.Value & " " & _
> " ORDER BY parts.lheight;"
>
> --
> Good Luck
> BS"D
>
>
> "Bonnie" wrote:
>
> > I'm having trouble with the multiple criteria in this code. It isn't
> > returning the record I know is there.
> >
> > Me.PWIDTH6.RowSource = "Select distinct parts.lheight " & _
> > "FROM parts " & _
> > "WHERE parts.ItemDesc = '" & descrip.Value & "' " & _
> > "AND parts.pwidth = '" & Text2.Value & "' " & _
> > "ORDER BY parts.lheight;"
> >
> > Can anyone help me?
> >
> > Thanks in advance,
> >
> > Bonnie

=?Utf-8?B?Qm9ubmll?= <(E-Mail Removed)> wrote in
news:E04D1EB2-919F-4961-A1EC-(E-Mail Removed):

> Hi Ofer,
>
> That wasn't the problem, I tried it both ways and get the same
> behaviour. Any other ideas?
>
> Thanks,
>
> Bonnie

Specify the form on which your controls reside, either by using Me!
or Forms!formname!
" WHERE parts.ItemDesc = '" & Me!descrip.Value & "' " & _
" AND parts.pwidth = " & Me!Text2.Value & " " & _


Q

>
> "Ofer Cohen" wrote:
>
>> Is the field "pwidth" type is numeric?
>> If so you need to drop the single quote, that you use only for
>> text fields
>>
>> Me.PWIDTH6.RowSource = "Select distinct parts.lheight " & _
>> "FROM parts " & _
>> " WHERE parts.ItemDesc = '" & descrip.Value & "' " & _
>> " AND parts.pwidth = " & Text2.Value & " " & _
>> " ORDER BY parts.lheight;"
>>
>> --
>> Good Luck
>> BS"D
>>
>>
>> "Bonnie" wrote:
>>
>> > I'm having trouble with the multiple criteria in this code. It
>> > isn't returning the record I know is there.
>> >
>> > Me.PWIDTH6.RowSource = "Select distinct parts.lheight " & _
>> > "FROM parts " & _
>> > "WHERE parts.ItemDesc = '" & descrip.Value & "' " & _
>> > "AND parts.pwidth = '" & Text2.Value & "' " & _
>> > "ORDER BY parts.lheight;"
>> >
>> > Can anyone help me?
>> >
>> > Thanks in advance,
>> >
>> > Bonnie
>



--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Thanks Bob, I'll play with that but there are two other combo boxes I am
using with the same syntax (one criteria) that are working fine.

Bonnie

"Bob Quintal" wrote:

> =?Utf-8?B?Qm9ubmll?= <(E-Mail Removed)> wrote in
> news:E04D1EB2-919F-4961-A1EC-(E-Mail Removed):
>
> > Hi Ofer,
> >
> > That wasn't the problem, I tried it both ways and get the same
> > behaviour. Any other ideas?
> >
> > Thanks,
> >
> > Bonnie
>
> Specify the form on which your controls reside, either by using Me!
> or Forms!formname!
> " WHERE parts.ItemDesc = '" & Me!descrip.Value & "' " & _
> " AND parts.pwidth = " & Me!Text2.Value & " " & _
>
>
> Q
>
> >
> > "Ofer Cohen" wrote:
> >
> >> Is the field "pwidth" type is numeric?
> >> If so you need to drop the single quote, that you use only for
> >> text fields
> >>
> >> Me.PWIDTH6.RowSource = "Select distinct parts.lheight " & _
> >> "FROM parts " & _
> >> " WHERE parts.ItemDesc = '" & descrip.Value & "' " & _
> >> " AND parts.pwidth = " & Text2.Value & " " & _
> >> " ORDER BY parts.lheight;"
> >>
> >> --
> >> Good Luck
> >> BS"D
> >>
> >>
> >> "Bonnie" wrote:
> >>
> >> > I'm having trouble with the multiple criteria in this code. It
> >> > isn't returning the record I know is there.
> >> >
> >> > Me.PWIDTH6.RowSource = "Select distinct parts.lheight " & _
> >> > "FROM parts " & _
> >> > "WHERE parts.ItemDesc = '" & descrip.Value & "' " & _
> >> > "AND parts.pwidth = '" & Text2.Value & "' " & _
> >> > "ORDER BY parts.lheight;"
> >> >
> >> > Can anyone help me?
> >> >
> >> > Thanks in advance,
> >> >
> >> > Bonnie
> >
>
>
>
> --
> Bob Quintal
>
> PA is y I've altered my email address.
>
> --
> Posted via a free Usenet account from http://www.teranews.com
>
>