Form based on a query

D

Dino

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?
 
J

Jerry Whittle

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.
 
D

Dino

Thanks Jerry, I will try that.

Jerry Whittle said:
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.
Click to expand...
 
Top