Form based on a query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dino - 17 Feb 2006 16:02 GMT

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?

Reply to this Message

Jerry Whittle - 17 Feb 2006 16:51 GMT

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.

Signature

Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

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

Reply to this Message

Dino - 17 Feb 2006 18:15 GMT

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.
[quoted text clipped - 7 lines]
> > 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?

Reply to this Message