Form to view older values.

  • Thread starter Thread starter Sharon
  • Start date Start date
S

Sharon

Hello,
Thanx for a positive help.
I am building a Form based on some queries. There are
prices displayed in 'textboxes' of the form.These take
theior value from a query.
My problem is that, I have to review and change these
prices very often in the query. This means that, I will
loose the old data in the query and the form.

Is there a way to retain these values in the text boxes of
the form?
That is, allowing the viewer to see the old prices, by
default and then allowing her to choose if she wants to
refresh the Form so that she can view the updated value.

Reg,
Sharon
 
If you set the recordset type of this form to snapshot then the values will
not get refreshed in the bound textbox but you are also not able to change
any data at the time.

So I think it's better to build an unbound form and to handle the data
yourself.

- Raoul

to get everything updated
 
you don't save data in forms or in queries, you save data in tables. your
form is based on your queries; each query is based on one or more tables.
the prices must be saved as data in your table(s), or calculated from data
saved in your table(s). not knowing anything about the structure of your
tables, my general suggestion would be for you to update the prices by
adding a new record in your table, rather than overwriting the prices in an
existing record. an alternative to that solution would be to create a
"historical" table for prices; when you need to update prices, first copy
the "old" price data into the historical table. then go ahead and update the
prices. once you've decided out how to handle the issue of storing new price
data in your table(s), while retaining old price data, then you can come up
with a way to make current and historical price data available to your user
via forms.

hth
 
Back
Top