Hi,
I have a main quote form with a quotenumber text box and
revision number text box and some other fields from a
quote header table.
I have a subform with fields from quotelineitem table
which displays the different items quoted with this quote
number - their unit price, quantity & total price.
When I double click one lineitem, it opens a new form with
much more details of that item, from quotelineitem table
like unitprice, total, quantity.
For eg:
For quotenumber "433" and revnumber "1" I have the main
form with details like customer info, along with a textbox
new rev number = 2.
The subform say, shows 2 lineitems soap & shampoo
1 soap 5 $45.00 $225.00
2 shampoo 4 50.00 $200.00
These items are for quotenumber 433 and revnumber 1
when I doubleclick on soap item, it opens a new form with
all details for that soap item. Say, if I change some
information, so that the quantity = 10 and total = $450.00
and i save and close, I am not able to see the changes on
the soap item on the subform. It still shows the previous
value of quanity = 5 and total = $225.00
when i close & save in my new form, i create a new record
in the table with new rev number. Is this the problem?
that the subform shows all details of previous
revisionnumber and now the changes are under the same
quotenumber but new revisionnumber?
I would appreciate your input!!
Thanks in advance
I have a main quote form with a quotenumber text box and
revision number text box and some other fields from a
quote header table.
I have a subform with fields from quotelineitem table
which displays the different items quoted with this quote
number - their unit price, quantity & total price.
When I double click one lineitem, it opens a new form with
much more details of that item, from quotelineitem table
like unitprice, total, quantity.
For eg:
For quotenumber "433" and revnumber "1" I have the main
form with details like customer info, along with a textbox
new rev number = 2.
The subform say, shows 2 lineitems soap & shampoo
1 soap 5 $45.00 $225.00
2 shampoo 4 50.00 $200.00
These items are for quotenumber 433 and revnumber 1
when I doubleclick on soap item, it opens a new form with
all details for that soap item. Say, if I change some
information, so that the quantity = 10 and total = $450.00
and i save and close, I am not able to see the changes on
the soap item on the subform. It still shows the previous
value of quanity = 5 and total = $225.00
when i close & save in my new form, i create a new record
in the table with new rev number. Is this the problem?
that the subform shows all details of previous
revisionnumber and now the changes are under the same
quotenumber but new revisionnumber?
I would appreciate your input!!
Thanks in advance