|
-
Dec 9th, 2008, 03:22 PM
#1
Thread Starter
New Member
Text Fields on Form to Parameters in Query
Hello,
I'm just learning (slowly), and am having trouble with the following.
I've got a query in MS Access (2003) with parameters of "city", "startDate" and "endDate". These are fixed so when you open the query, the parameter windows pop up for you to fill in.
I am trying to create a form where a user can fill in the above information, click the button and have the user defined text fields take the place of those parameter windows above. (Or have them collect the info from the form and not pop up.)
Also, I would like for a field of the query result to show in a separate text box on the form once complete. (This would be a percentage that I would need a format change from the query result.)
Thanks in advance for your assistance!
Last edited by K8Shrew; Dec 9th, 2008 at 04:24 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|