RE: 2 ID's 1 Name

I'll add to make the size of the second column 0 in the properties of the
combo box if it is showing and you don't want to see the ID.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"KARL DEWEY" wrote:

> Try this --
> SELECT tblMVUP.ChemicalName, First(tblMVUP.ID) AS SelectID
> FROM tblMVUP
> WHERE (((tblMVUP.Active)=-1))
> GROUP BY tblMVUP.ChemicalName
> HAVING (((tblMVUP.ChemicalName)<>""))
> ORDER BY tblMVUP.ChemicalName;
>
> I used a Yes/No field for tblMVUP.Active.
>
> You would have column 2 as the bound column.
>
>
>
> "Brad" wrote:
>
> > Thanks for taking the time to read my question.
> >
> > I have a product list that has an ID for every product. Each product has a
> > name and a size. I have a combo box on one form where size doesn't matter
> > (ha ha ha) but I need to limit the combo box list to only 1 of each product.
> > I need the ID as a hidden column so that I can stor it in the table.
> >
> > ID Product Size
> > 1 paint 1 Litre
> > 2 paint 4 Litre
> > 3 brush Small
> > 4 brush Large
> >
> > and so on...
> >
> > I want my combo box to list:
> > paint
> > brush
> >
> > I don't care what ID I store. How can I do this? If I group each ID is
> > displayed, If I choose First, I get the First ID, and only one record.
> >
> > I need one of each product name, and any associated ID.
> >
> > SQL:
> > SELECT tblMVUP.ID, tblMVUP.ChemicalName, tblMVUP.Active
> > FROM tblMVUP
> > GROUP BY tblMVUP.ID, tblMVUP.ChemicalName, tblMVUP.Active
> > HAVING (((tblMVUP.ChemicalName)<>"") AND ((tblMVUP.Active)=True))
> > ORDER BY tblMVUP.ChemicalName;
> >
> >
> >
> > Thanks,
> >
> > Brad
.

Relevant Pages

  • sort a subform containing 2 combo boxes
    ... My subform contains 2 combo boxes which bound by their first ... column but showing the second column. ... Is there a way that I can sort first by Combo1, ...
    (microsoft.public.access.formscoding)
  • Newbie question - reading delimited files and printing...
    ... Searching for a element in one field and then showing certain fields where ... I want all rows with YOU in second column and I want to print out 2nd and ... Please email to my home email. ...
    (comp.lang.java.programmer)
  • Newbie question...reading delimeted files then printing certain fields and doing calculations.
    ... Searching for a element in one field and then showing certain fields where ... I want all rows with YOU in second column and I want to print out 2nd and ... I want an average of response time broken down by hour. ... Please email to my home email. ...
    (comp.lang.java)
  • Re: Multiple Columns in a Combobox
    ... CustomerID and Customer Name. ... I would like to have a description showing in the first ... > column and an ID showing in the second column. ... > is made have the value from the second column populate the combobox ...
    (microsoft.public.windowsce.embedded.vb)