R
Rob Cooney
I have a query that is based on a table. I would like the table to
automatically update when I input data into a form so that the query will
produce the correct results.
For instance, on my form I have the Product Number and what it's description
is (two seperate entries). These I don't need to update since I am using the
"find" feature to locate these products.
However, in the sub form I have entries for Bid Qty, Bid Per Unit, Bid
Income and P&L Impact. I want to manually input the Bid Qty and Bid Per Unit
numbers, then use a calculation such as [Bid Qty]*[Bid Per Unit] to give me
the Bid Income which the P&L query will use to generate the correct results.
Unfortuantely I am having a problem getting the form to update the table
where the Bid Income is located and that the query is running off of. Right
now I have to manually go into the table and enter the Bid Income number once
it is generated on the form.
The other problem that I've run into in trying the update query option is
that it inputs the same bid income for each product number, which is no good.
If anyone has an idea on how to accomplish this, please let me know.
automatically update when I input data into a form so that the query will
produce the correct results.
For instance, on my form I have the Product Number and what it's description
is (two seperate entries). These I don't need to update since I am using the
"find" feature to locate these products.
However, in the sub form I have entries for Bid Qty, Bid Per Unit, Bid
Income and P&L Impact. I want to manually input the Bid Qty and Bid Per Unit
numbers, then use a calculation such as [Bid Qty]*[Bid Per Unit] to give me
the Bid Income which the P&L query will use to generate the correct results.
Unfortuantely I am having a problem getting the form to update the table
where the Bid Income is located and that the query is running off of. Right
now I have to manually go into the table and enter the Bid Income number once
it is generated on the form.
The other problem that I've run into in trying the update query option is
that it inputs the same bid income for each product number, which is no good.
If anyone has an idea on how to accomplish this, please let me know.