 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / November 2005get query values
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 >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] > >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 [quoted text clipped - 5 lines] > > 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? >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] > >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 [quoted text clipped - 7 lines] > > 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 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.