get query values

[zenonk]

I have an Access application in which upon button click, a query is
run. I can run the query based on the value of a text box, but I am
having problems accessing the rest of the values returned. Can anyone
tell me how to do this? I was trying it thusly

As the form is opened, I run a macro that runs a query called
qry_t&r_pricing based on a textbox on the form. The query has a field
called Price from a table called tbl_t&RPricing. The query runs fine
but I don't know how to access it's returned values.

thanks,

Z

 

[John Vinson]

As the form is opened, I run a macro that runs a query called
qry_t&r_pricing based on a textbox on the form. The query has a field
called Price from a table called tbl_t&RPricing. The query runs fine
but I don't know how to access it's returned values.

Base a Form on the query and, rather than running the query, open the
Form.

John W. Vinson[MVP]

 

[zenonk]

Base a Form on the query and, rather than running the query, open the
Form.

John W. Vinson[MVP]

The form is based on a query and there are thousands of records in the
underlying tables. Now I need to add a new lookup table which is not
connected with the form query... therein lies my problem. Is this
doable?

 

[John Vinson]

The form is based on a query and there are thousands of records in the
underlying tables. Now I need to add a new lookup table which is not
connected with the form query... therein lies my problem. Is this
doable?

Sure; just link it to the Form's query. Or, put a textbox on the Form
using DLookUp() to look up the value in this table.

I'm not sure I understand the context!

John W. Vinson[MVP]

 

[zenonk]

Sure; just link it to the Form's query. Or, put a textbox on the Form
using DLookUp() to look up the value in this table.

I'm not sure I understand the context!

John W. Vinson[MVP]

I was having trouble with null results in the query when I joined the
new lookup table to the table behind the form. After working on it for
a while, turns out I just had a bad join property... I modified it per
your original suggestion and it is now properly joined. thanks for
your help.

Z