Solved

set a query parameter to a form control

Posted on 2011-09-11
7
314 Views
Last Modified: 2012-06-27
How or can I set a query parameter to a form control (combo box selection).  I believe i done it before but im new to Access 2010.  I used previous versions.

Thanks in Advance!!
0
Comment
Question by:IT_newbie01
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 350 total points
ID: 36520200
You mean like this:

SELECT Table1.*
FROM Table1
WHERE (((Table1.FIELD1)=[Forms]![YourFormName]![YourCombBoxName]));


mx
0
 

Author Comment

by:IT_newbie01
ID: 36520229
Yes, but how do i do that at the query level or how do i get to the SQL section of the query to apply that where clause in Access 2010??
0
 

Author Comment

by:IT_newbie01
ID: 36520335
I've requested that this question be closed as follows:

Accepted answer: 0 points for IT_newbie01's comment http:/Q_27302500.html#36520229

for the following reason:

Actually that worked in the design view of the query. &nbsp;I had another query running that was throwing an error.<br /><br />Thanks!
0
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 
LVL 75
ID: 36520297
What worked ?
0
 
LVL 75
ID: 36520336
"Actually that worked in the design view of the query."

What worked?  I believe I answered your question.
0
 

Author Closing Comment

by:IT_newbie01
ID: 36520377
You were right.  Thanks.
0
 

Author Comment

by:IT_newbie01
ID: 36520384
I meant to award you the points originally.  I was saying "Actually that worked in the design view of the query." meaning your code worked in the design view of the query .  Thanks!!!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question