Overwriting Fields

[Ben Rudder]

Hi I am a beginner designing a system for a shellfish
exporting company. I have a report that takes weights
and mulitplies by a price.
(A different price per kilo for each species). So each
species has its corresponding price which is stored in
its own table. I want to create a form that updates the
price of each species, but when a new price is entered, I
need it to overwrite the old price, not just put it in a
new record. Because otherwise my report does not work
correctly.

Greatful for any suggestions

 

[Jake]

One way that comes to mind is to create a form with just
the species name and price listed. Species name would be
Enabled = False; Locked = True. Set the form with Allow
Additions = No, Allow Edits = Yes, Data Entry = No,
Navigation Buttons = Yes and you will be able to click
through each type of shellfish and change the price
(without changing the name). Keep in mind this will also
change the calculation for historical data, so you may
want to store the price per batch/order with the sales
record. If you wanted something a little more spiffy (to
find the species), check out cboMoveTo at:

http://users.bigpond.net.au/abrowne1/ser-03.html

HTH
Jake