Form based on a query

[Guest]

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?

 

[Guest]

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.

 

[Guest]

Thanks Jerry, I will try that.

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.