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
12-Jul-2012, 09:06 AM #76
Just some information:

My first combo box is labeled "Category" and is numbered by Access as Combo23

My second combo box is labled "Detail1" and is numbered by Access as Combo25

My Subform is labeled "Vendor Name"

The query I created and am using is VendorProduct/Service Query and contains 4 columns (Category, Detail1, Vendor Name and SAP Vendor #)
Attached Files
File Type: zip Access Screenshots.zip (410.1 KB, 3 views)
Butterfly807's Avatar
Butterfly807 Butterfly807 is offline
Member with 70 posts.
THREAD STARTER
 
Join Date: Jun 2012
12-Jul-2012, 09:07 AM #77
Also... my Form name is titled "Product/Service1".... I don't know if you need to know that.
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,649 posts.
 
Join Date: Mar 2005
Location: UK
12-Jul-2012, 10:30 AM #78
You do not seem to have a query specifically for the subform.
__________________
OBP
I do not give up easily
Butterfly807's Avatar
Butterfly807 Butterfly807 is offline
Member with 70 posts.
THREAD STARTER
 
Join Date: Jun 2012
12-Jul-2012, 10:33 AM #79
Perhaps I do not understand. Do I need a separate query for the subform? I created one that is titled "VendorProduct/Service Query" and I linked the combo boxes to it. The Source Object for the Subform is that same Query.

What am I doing wrong?
Butterfly807's Avatar
Butterfly807 Butterfly807 is offline
Member with 70 posts.
THREAD STARTER
 
Join Date: Jun 2012
12-Jul-2012, 11:00 AM #80
Also, I don't like the format of the query as the subform. I like being able to set up my own format for the subform like I can if the subform pulls from a table instead of a query.
Butterfly807's Avatar
Butterfly807 Butterfly807 is offline
Member with 70 posts.
THREAD STARTER
 
Join Date: Jun 2012
12-Jul-2012, 11:12 AM #81
Do I need to enter an Event under 'On Enter' or 'On Exit' for the subform? I just don't get why I can't get this to work. It's driving me nuts.
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,649 posts.
 
Join Date: Mar 2005
Location: UK
12-Jul-2012, 11:16 AM #82
You can set up the subform any way you like, how did it get to be the way it is now?

The 2 queries that you show for the combos in the pdf document are fine for the combos, but the subform needs one that has the Details filtered by the Combo25 selection, (it may not need combo23 as well as it has already been used in the combo25 filter).
__________________
OBP
I do not give up easily
Butterfly807's Avatar
Butterfly807 Butterfly807 is offline
Member with 70 posts.
THREAD STARTER
 
Join Date: Jun 2012
12-Jul-2012, 11:21 AM #83
When I select the source of the subform to be a query, it looks like a query, not where I can add a header and footer and box selections I would like to appear. I can only get it to look the way I want to if the Subform source is from a subform I used when creating a separate form from a table.

How do I have a query that has the Details filtered by the Combo25 selection? Do I create a separate query with only Detail1, Vendor Name and SAP Vendor #? How do I link that to the subform and add a form header, detail and form footer section to it?
Butterfly807's Avatar
Butterfly807 Butterfly807 is offline
Member with 70 posts.
THREAD STARTER
 
Join Date: Jun 2012
12-Jul-2012, 11:28 AM #84
This makes no sense to me. When I link a query to the subform, it looks like image #1 in my attachment. I don't want this. It's just the query pasted into my form. Also, it does not filter based on the selections of my combo boxes.

What I want is for my form to look like image #2. The problem is, this is me linking a subform to my subform, and it won't filter based on the selections of the combo boxes.
Attached Files
File Type: zip Access Screenshots2.zip (203.8 KB, 5 views)
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,649 posts.
 
Join Date: Mar 2005
Location: UK
12-Jul-2012, 11:31 AM #85
The first form in your pdf has it's "Default View" set to Datasheet or Continuous forms mode, the second one is set to Single Form mode.
__________________
OBP
I do not give up easily
Butterfly807's Avatar
Butterfly807 Butterfly807 is offline
Member with 70 posts.
THREAD STARTER
 
Join Date: Jun 2012
12-Jul-2012, 11:33 AM #86
What do those mean? And what do I need to do to achieve a subform that produces filtered results from the combo boxes in the format that I want?
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,649 posts.
 
Join Date: Mar 2005
Location: UK
12-Jul-2012, 11:37 AM #87
Have you looked at the Form's Properties?
The 6th item down is the default view.
To get the form filtered it has to be based on a query that is filtered by Combo25.
__________________
OBP
I do not give up easily
Butterfly807's Avatar
Butterfly807 Butterfly807 is offline
Member with 70 posts.
THREAD STARTER
 
Join Date: Jun 2012
12-Jul-2012, 11:37 AM #88
Where do I change form modes and what form mode should I have it set to? Should it be linked to a query or a subform? Can you run down the steps for me as if I'm creating a new form. I've been working on this one for weeks now and it's just not working. Apparently I'm missing something and I can't figure out what it is.
Butterfly807's Avatar
Butterfly807 Butterfly807 is offline
Member with 70 posts.
THREAD STARTER
 
Join Date: Jun 2012
12-Jul-2012, 11:40 AM #89
Where do I find the form properties? I can only find the properties for the individidual combo's and the subform.
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,649 posts.
 
Join Date: Mar 2005
Location: UK
12-Jul-2012, 11:42 AM #90
You need to create a query based on the table that provides the details, it neds to be filtered by the combo25.
When you have created that check that it works with different selections of combo25 you can then create a form.
__________________
OBP
I do not give up easily
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.


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

Forum Jump

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