[AccessD] lock data2

Hi,

this problem was badly explained, so i will try again.

I have a table in which data about bricks and their prices are stored.
I use this data in a form where the orders of these bricks are stored. The
prices of the bricks are used only as lookup (the price can't be changed by
hand on this form).
The prices in this form are used to make bills by mail merge with word.
When the price of a brick (for example A)  changes and the price in the
table for brick A is will be changed to.
When opening the order form and changing other data in the order for brick A
the original price will be updated with the new price.
How can i prevent this. When i place a order, the price at the date of the
order must stay on the form, even when the price of this brick is changed in
the table.

Pedro Janssen

----- Original Message -----
From: "Pedro Janssen" <pedro at plex.nl>
To: <AccessD at databaseadvisors.com>
Sent: Thursday, April 28, 2005 2:21 PM
Subject: [AccessD] lock data


> Hello Group,
>
> i have a form that is using a table to store its data of stone prices.
When the prices in the table changes, the data on the form also changes.
>
> I would like that the prices can not change, after it is places on the
form the first time, when the record is opened.
>
> TIA
>
> Pedro Janssen
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>