I am trying to run a query based on the value of a user input in one field of a form and display the results as a subform. The query and subform work, but when I try to go into the form I get two prompts for the value. Is there any way to have the SQL query use the input in the form and not display a pop-up dialog asking for the input. Also, and this is a stupid question, I am wanting this same form to take two numerical values that are entered by a user and muliply them for display in a third field and I can't get it to work.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
User Input in SQL query 1
- Thread starter bgroce
- Start date
- Thread starter
- #21
- Thread starter
- #22
Here is another question on this: I have been using the requery and it is showing me the data great, but is there a way to take the fields returned by the query and copy them into the respective fields of the new record. In real words what I am trying to do it take duplicate customer information and save us the trouble of re-entering it for every record for a particular customer. Thanks
- Status
Similar threads
