Hi,
Have a couple of questions!
I have a mainform - revisequoteform displaying details of a quote (like customer info, revision number etc)
Within this mainform - have a revisesubform with all item details for that quote. I can create a quote with any number of items in it.
This subform shows all the items quoted for, but just a couple fields for each item.
When I double click any item on the subform , I open another form (new popup form) which displays all the details for that item in that quote.
What Im trying to achieve?
1. When I revise the item details in the new pop up form, close this form, I would like to update the changes on to the revisesubform for this item.
Problem is: WHen i first open this revisemainform - it gets the last revised quote information for that quotenumber - say last rev number = 1 - new rev num = 2 and when I revise this again using the popupform, Im not able to update the changes to the revisesubform since it displays still the item details for the rev number 1.
2. For one quotenumber, say I have 3 items.But i revise just one item, and do not touch the others. When I open the quote again, only the revised item appears for the quotenumber on the subform, the remaining unrevised items are not displayed.
For this, Im trying to copy the entire item record thats unrevised , to the same table, but with new revisiion number. Is there a way to duplicate a record without assigning each and every field?
I would appreciate any input.
Thanks in advance
Priya
Have a couple of questions!
I have a mainform - revisequoteform displaying details of a quote (like customer info, revision number etc)
Within this mainform - have a revisesubform with all item details for that quote. I can create a quote with any number of items in it.
This subform shows all the items quoted for, but just a couple fields for each item.
When I double click any item on the subform , I open another form (new popup form) which displays all the details for that item in that quote.
What Im trying to achieve?
1. When I revise the item details in the new pop up form, close this form, I would like to update the changes on to the revisesubform for this item.
Problem is: WHen i first open this revisemainform - it gets the last revised quote information for that quotenumber - say last rev number = 1 - new rev num = 2 and when I revise this again using the popupform, Im not able to update the changes to the revisesubform since it displays still the item details for the rev number 1.
2. For one quotenumber, say I have 3 items.But i revise just one item, and do not touch the others. When I open the quote again, only the revised item appears for the quotenumber on the subform, the remaining unrevised items are not displayed.
For this, Im trying to copy the entire item record thats unrevised , to the same table, but with new revisiion number. Is there a way to duplicate a record without assigning each and every field?
I would appreciate any input.
Thanks in advance
Priya
