Re: Pull Downs

Yes combo boxes. I don't think you would want to use the second combo as a
subform, because when you select a record in the second combo, it then
displays that data for that record in the form, the same form the two combo
boxes are in.

Combo 1: Source is a query I made that has the categorys I want, company
name, phone, etc.

Combo 2: Source is table/query with this:

SELECT DISTINCT [Contact] FROM SearchByPotentialQuery ORDER BY [Contact];

Do you want me to upload a blank database on the Internet that has all my
forms but no data?

Thanks
Curtis

By "pull downs" I am assuming you mean comboboxes, right? My answer would
still work by using a sub form to display more than one record for a single
company. Your main form has a record source of the company table, right?
Then is there another table that has the info you are looking for? Like
Company table, then order table, as an example? The subform would show the
orders for that company ID if there is a foreign id in the order table to
companyid. the Master and Child link would be CompanyID, and the subform
would show all records for that company.

Damon

"Curtis Stevens" <CurtisStevens@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9E363879-A2F9-4C9A-94F4-8652E121A108@xxxxxxxxxxxxxxxx
Maybe I'm not explaining it very well, these two pulls downs are used to
pull
up a record. I select company name, then select one, which then displays
the
info on that form, the form these two pull downs are on.

Pull Down 1: Search By
Pull Down 2: Search For

Curtis

Use a subform instead of the second combobox.

Damon

"Curtis Stevens" <CurtisStevens@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:8325364C-F54C-4A7B-A347-D696DB7AA305@xxxxxxxxxxxxxxxx
I have two pull downs, the second pull down feeds off from the first
one.

First one has the critera to search by, company name, phone number,
etc.

Second pull down displays the data.

When I have two records with the same company name, it only displays
ONE,
not both. How do I get it to display both?

If you need more explanation, let me know.

Curtis







.

Relevant Pages

  • Re: error 3048 - Cannot open any more databases
    ... The combo that uses the callback function as its RowSourceType will still be able to display the desired data. ... What happens is that you load the static array one, and then it calls the callback function whenever it needs a value. ... I am using these combo boxes not only as a way of selecting a ... > the same subform, just inserted 48 times. ...
    (microsoft.public.access.formscoding)
  • Re: error 3048 - Cannot open any more databases
    ... Yes the bound column of my combo boxes are not the display column. ... decrease my open connections, since ultimately that is what I am after. ... the same subform, just inserted 48 times. ...
    (microsoft.public.access.formscoding)
  • Requery problem
    ... I have a form with a subform. ... a continuous form to display the records that the two combo boxes select. ... Private Sub cbxCatalogVers_AfterUpdate ... If you could help shed some light on why I can't my subform to display the ...
    (microsoft.public.access.forms)
  • RE: value with check box
    ... the other nine form controls are meant to display other columns ... > with the names of your checkbox and combo box controls, ... >> I have set up a form with 10 fields set up as combo boxes. ... >> lose the ability to pull different values from source table, ...
    (microsoft.public.access.forms)
  • Re: Pull Downs
    ... (incidently, a combobox can't be a subform, they are two different objects). ... The second combo in your example filters the results ... display the results in the subform. ... the form these two pull downs are on. ...
    (microsoft.public.access.forms)
Loading