• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 341
  • Last Modified:

set a query parameter to a form control

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
IT_newbie01
Asked:
IT_newbie01
  • 4
  • 3
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
You mean like this:

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


mx
0
 
IT_newbie01Author Commented:
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
 
IT_newbie01Author Commented:
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
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
What worked ?
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"Actually that worked in the design view of the query."

What worked?  I believe I answered your question.
0
 
IT_newbie01Author Commented:
You were right.  Thanks.
0
 
IT_newbie01Author Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now