creating temporary data - possibly for later export

[Guest]

I am trying to create a form where the user can select several choices of
styles, components, etc from dropdown lists (coded through the properties).
My intent is to have a list of components, with their associated prices
populate a table that can later be printed out as something like an invoice.
One criteria is that this data can change as the selections change (hence
temporary table) and once everything is satisfactory - move this data into a
more permenant table.

example:
customer: 34
select "Style" ex "Modelx"
select "component" ex "part 3"
lookup price of part3 for Modelx from tblComponentPrices = 2.00
display Modelx part3 $2.00
change style to ModelQ
lookup price of part3 ModelQ from tblComponentPrices = 5.43
change display to ModelQ part3 $5.43

OK =save to tblOrder
custID=34
Style=ModelQ
component = part3

Any Ideas?

Thanks, Brian

 

[jahoobob via AccessMonster.com]

As long as you are on one record, you can change the fields on a form as many
times as you want and the editted values will be "saved" in the table.

 

[Guest]

I guess what I am trying to say is that I want to create a form that will
create a list of components with their associated prices, that can be changed
depending on criteria set in the form header, but not saved to a table until
the final list is approved. Kinda like a spreadsheet where you change one
cell and it can impact another.

 

[jahoobob via AccessMonster.com]

As long as you have focus of one record in a form it is akin to changing the
cells in say one row of a spreadsheet to test various scenarios.
If you still want to do it your way, then you can create a form of unbound
boxes and once you've finished manipulating your entries select a button on
the form that saves the values to a table.

I guess what I am trying to say is that I want to create a form that will
create a list of components with their associated prices, that can be changed
depending on criteria set in the form header, but not saved to a table until
the final list is approved. Kinda like a spreadsheet where you change one
cell and it can impact another.

As long as you are on one record, you can change the fields on a form as many
times as you want and the editted values will be "saved" in the table.

[quoted text clipped - 25 lines]