Using form input for queries

[randommetalguy]

Here is my problem. I have a database with 7 tables. I need to extract information from them based on input a user enters.

I'm going to have 3 text boxes on a form. The first two get multiplied and divided by the third to come up with a look up value. The fourth value that is generated will be used along with the previous three to get information out of the 7 tables.

Are there any articles you can direct me to or books that would be helpful in solving this problem?

There is a part two where the information needs to be displayed on a form and I will probably need basic information on how to do that as well.

Thanks!

 

[Alansidman]

This may help you get started.

http://www.datapigtechnologies.com/flashfiles/searchform.html

Alan

 

[randommetalguy]

That video is excellent. How would I store the 4th variable though. How would I tell it to multiple the 3 inputs together and store that number somewhere so that I can generate a query?

 

[Alansidman]

In an unbound text box, do your calculations for your bound text boxes. Use this unbound text box as one of the source values on your search form as shown in the video. You don't want to store any of the calculations, you only want them to be used for the query.

Alan