Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Solved: Access 2010 Search


(!)

Butterfly807's Avatar
Butterfly807 Butterfly807 is offline
Member with 70 posts.
THREAD STARTER
 
Join Date: Jun 2012
27-Jun-2012, 03:44 PM #16
Lol! I was just going to tell you that I figured it out by going off what you already told me. You already gave me the answer.

You've been so helpful! Just want to say..
Butterfly807's Avatar
Butterfly807 Butterfly807 is offline
Member with 70 posts.
THREAD STARTER
 
Join Date: Jun 2012
29-Jun-2012, 01:45 PM #17
Is this possible?
Is it possible to link multiple subforms in a mainform? For example, what I would like to do is have a Product/Service Search Form. It would work this way:
1. User would select a product/service category such as "Gasket"
2. User would then select the type of gasket such as "Garlock"
3. User then receives list of suppliers that provide Garlock Gasket

I'm having difficulty setting it up where I select Gasket, and then in a second combo box appears only the type of gaskets, to then produce a result of suppliers.

Does this make sense?
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,610 posts.
 
Join Date: Mar 2005
Location: UK
29-Jun-2012, 02:10 PM #18
The simplest way is to Filter the second Combo based on the selection of the first combo, this is achieved using the second combo box's SQL (query) Row Source.
You use the the Criteria
Forms![Formname]![firstcomboname]
Butterfly807's Avatar
Butterfly807 Butterfly807 is offline
Member with 70 posts.
THREAD STARTER
 
Join Date: Jun 2012
29-Jun-2012, 02:59 PM #19
I've set it up the way you've described, but my second combo box is coming up blank.
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,610 posts.
 
Join Date: Mar 2005
Location: UK
30-Jun-2012, 05:19 AM #20
The second part is to use VBA in the first Combo's After Update event procedure to requery the second combo with
me.secondcomboname.requery
Butterfly807's Avatar
Butterfly807 Butterfly807 is offline
Member with 70 posts.
THREAD STARTER
 
Join Date: Jun 2012
03-Jul-2012, 11:04 AM #21
I'm not understanding...
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,610 posts.
 
Join Date: Mar 2005
Location: UK
03-Jul-2012, 11:52 AM #22
Do you know how to open the Combo's After Update Event Procedure?
Butterfly807's Avatar
Butterfly807 Butterfly807 is offline
Member with 70 posts.
THREAD STARTER
 
Join Date: Jun 2012
03-Jul-2012, 12:01 PM #23
I know how to open a combo to edit after I've created them. I'm not sure what you mean by 'After Update Event Procedure' though.
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,610 posts.
 
Join Date: Mar 2005
Location: UK
03-Jul-2012, 12:20 PM #24
OK, in the Properties go to the Event Tab and the After Update event is the 3rd one down. Click on it and select "Event Procedure" and then click on the 3 small dot builder on the right, it will take you to the VBA Editor at the correct event.
__________________
OBP
I do not give up easily
Butterfly807's Avatar
Butterfly807 Butterfly807 is offline
Member with 70 posts.
THREAD STARTER
 
Join Date: Jun 2012
03-Jul-2012, 12:41 PM #25
Ok, I've found that. I'm not sure what I do once in the After Update. If I select Requery, I don't know how to proceed. Sorry for all the questions.
Butterfly807's Avatar
Butterfly807 Butterfly807 is offline
Member with 70 posts.
THREAD STARTER
 
Join Date: Jun 2012
03-Jul-2012, 12:43 PM #26
.. And is there a way to prevent duplicates? For example, in my first combo, 'gasket' is listed about 10 times because there are 10 different possible gaskets. I want it to only be listed once.
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,610 posts.
 
Join Date: Mar 2005
Location: UK
03-Jul-2012, 12:48 PM #27
You should add Grouping to the first combo SQL (Query).

Once you are in the after update event you can type in

me.

the VBA editor will now list the controls available, go down the list and find your second combo and select it then type another

.r

and it will list what you can do with the combo starting with an r, go down the list and select requery.
Then click save.
Butterfly807's Avatar
Butterfly807 Butterfly807 is offline
Member with 70 posts.
THREAD STARTER
 
Join Date: Jun 2012
03-Jul-2012, 12:59 PM #28
I know I'm going to drive you crazy today. How do I add Grouping?
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,610 posts.
 
Join Date: Mar 2005
Location: UK
03-Jul-2012, 01:25 PM #29
If the Ribbon is the same as 2007 you use the "Totals" at the right hand end when in design view.
Butterfly807's Avatar
Butterfly807 Butterfly807 is offline
Member with 70 posts.
THREAD STARTER
 
Join Date: Jun 2012
05-Jul-2012, 03:23 PM #30
I am in 2010. I do not see anything that says "totals"
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑