What exactly do you need to do? If you have some complex vb that returns a specific value, you may be best off dynamically building the query at runtime. Otherwise you may be able to get by using simple parameter queries. What is it that you need to do?
I have a report based on a simple query based on a customer. The query has a parameter for a customer ID (primary key) and therefore only reports one record. I want to be able to call this report up from other forms in my database, and pass the customer ID (known at run-time) to the report via vb so the user does not have to input the ID again via the query input box.
That sounds great, but it assigns the query to the one textbox. Is there anway that I could have various textboxes in various forms and call the query from there passing the value in the textbox? Thanks very much for you help.