Re: Pull Downs
- From: "Damon Heron" <damon327@xxxxxxxxxxx>
- Date: Wed, 21 Feb 2007 12:45:58 -0800
No, you misunderstand my last answer. If both combo boxes act as filters to
limit the data you want displayed, then leave them as is. But add a subform
to display the data you want - your original question said that only one
record was displayed when there may be more than one for each company.
(incidently, a combobox can't be a subform, they are two different objects).
I am not totally clear on what you are trying to accomplish. How many
tables are involved? Are the tables relational? Access is a relational
database application. The second combo in your example filters the results
of the first combo by??? or vice versa?
Here is an example: 1st combobox selects Company "A", 2nd combobox uses
result of 1st ("A") and shows all company A contacts.
In second combobox, select one of the contacts. In the after update event
display the results in the subform. It may be one or many records for that
contact.... Are we on the same page?
Damon
"Curtis Stevens" <CurtisStevens@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CF4BC688-7326-49F1-B0D7-CA84242A7248@xxxxxxxxxxxxxxxx
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
.
- References:
- Re: Pull Downs
- From: Damon Heron
- Re: Pull Downs
- From: Damon Heron
- Re: Pull Downs
- From: Curtis Stevens
- Re: Pull Downs
- Prev by Date: Re: Combo box won't accept value
- Next by Date: ActiveX Office Viewer
- Previous by thread: Re: Pull Downs
- Next by thread: Re: Pull Downs
- Index(es):
Relevant Pages
|
