Results 1 to 4 of 4

Thread: Text Fields on Form to Parameters in Query

Threaded View

  1. #1

    Thread Starter
    New Member
    Join Date
    Dec 2008
    Location
    Salt Lake City, UT
    Posts
    2

    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
  •  



Click Here to Expand Forum to Full Width