Re: Posted before didn't get a response- populating dropdown 2 sources

Tech-Archive recommends: Speed Up your PC by fixing your registry

I take it that you have a combo box on a form, but I do not follow the
details. When you say "populating the dropdown" are you referring to the
combo box row source? Why do job# and taxempt# appear in the same combo
box? What is the taxes table? Are you copying records from one table to
another? If so, that is at least part of the problem, as you should not be
doing that.
What is the purpose of your database? What real-world situation are you
attempting to address?
As a possible answer to your question, you could try adding the word
DISTINCT after SELECT in the row source SQL. Another way of doing this:
select the combo box, click View > Properties, click the Data tab, click Row
Source, click the three dots. In the query design view that appears, click
View > Properties, and set Unique Values to Yes.
However, if your database is not set up properly, you may not get the
desired result. In that case, you will need to describe the database
structure and relationships.

"babs" <babs@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:488EA099-1583-4447-A325-CED0D6D24A0A@xxxxxxxxxxxxxxxx
I have a drop down list for job# on a form called quotes showing the job#
and
taxexempt # based on client id. Right now I am populating the dropdown
based
on previous entries on the existing form that enter the data into a table
called quotes. I would like to do either of two things. 1. Add these
entries(one entry per clientid, job#,taxexempt#) into another table called
taxex table.

Definitely want to know at least this. Have the user be able to add
clientid, job#, and taxempt# to the Taxex table and it ALSO be able to
show
up in the dropdown as a choice as well as the records previously input
into
the quote entry form. Not sure how to pull from two sources and only
display
once if duplicates- for a given drop down.


Thanks so much,
Barb


.

Relevant Pages

  • Re: Datagird Question?
    ... > How do we retrieve the ids of controls that datagrid generates at runtime. ... You can retrieve id of controls using ClientID property. ... Marshal Antony ... from the server side.I have a button and dropdown list as template columns ...
    (microsoft.public.dotnet.framework.aspnet.datagridcontrol)
  • Re: Row source question.
    ... Well, if I add a listbox to the form, with the same row source, then it works. ... event is a different sheet. ... When you say that the combobox was blank, do you mean the value of the combobox ... When you use the dropdown arrow, do you see a very short dropdown area--like ...
    (microsoft.public.excel.programming)
  • RE: Bound dropdownlist in .NET 2.0 -- picking the selected value?
    ... I need the dropdown list of clients to preselect the ClientID from the order. ... > datasource you use the SelectedValue of the object it is bound to. ...
    (microsoft.public.dotnet.framework.aspnet.webcontrols)
  • RE: Bound dropdownlist in .NET 2.0 -- picking the selected value?
    ... > I need the dropdown list of clients to preselect the ClientID from the order. ... >> datasource you use the SelectedValue of the object it is bound to. ...
    (microsoft.public.dotnet.framework.aspnet.webcontrols)
  • Re: Urgent: Please need help badly
    ... i figured that out by moving my code where i populated the dropdownlist into the sub page_load and there it works fine. ... Please review the following specific parse error details and modify your source file appropriately. ... Are you populating the dropdown in on page load event? ...
    (microsoft.public.dotnet.framework.aspnet.webcontrols)