If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Form based on a query
The information on my form is based on query results. I would like some of
the info to be based on calculations from a table instead. It would be the same table every time no matter what the query results are, but the calculation results would be different. How would I get started with that? |
#2
|
|||
|
|||
Form based on a query
You have a couple of choices. One would be to put upbound text fields on the
form and use something like DLookUp to pull in the data. You could also create a form from the other table's data and use it as a subform on you main form. This subform would probably not be linked to the main form. -- Jerry Whittle Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Dino" wrote: The information on my form is based on query results. I would like some of the info to be based on calculations from a table instead. It would be the same table every time no matter what the query results are, but the calculation results would be different. How would I get started with that? |
#3
|
|||
|
|||
Form based on a query
Thanks Jerry, I will try that.
"Jerry Whittle" wrote: You have a couple of choices. One would be to put upbound text fields on the form and use something like DLookUp to pull in the data. You could also create a form from the other table's data and use it as a subform on you main form. This subform would probably not be linked to the main form. -- Jerry Whittle Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Dino" wrote: The information on my form is based on query results. I would like some of the info to be based on calculations from a table instead. It would be the same table every time no matter what the query results are, but the calculation results would be different. How would I get started with that? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Move feild entries from form to form using global variables | JackCGW | General Discussion | 11 | November 14th, 2005 05:22 AM |
Design help, please | SillySally | Using Forms | 27 | March 6th, 2005 04:11 AM |
Union Query Not Returning A Value | Jeff G | Running & Setting Up Queries | 2 | October 19th, 2004 05:47 PM |
Big number gives error! | Sara Mellen | Running & Setting Up Queries | 8 | October 11th, 2004 02:48 AM |
Report Based Upon Parameter Query with Form References | Vincent DeLuca | Setting Up & Running Reports | 4 | July 19th, 2004 01:55 AM |