M
[MVP] S.Clark
Using a little VBA code behind the form, you can perform the update. In the
After Update of the combo, check for the conditions, then populate as
needed.
It should not require changes to your queries, if I read your statement
correctly, that is.
--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting
From: "Michael Dane" <[email protected]>
Subject: Lookup
Date: Monday, November 29, 2004 11:43 AM
I have a form that is based on a table called "Data"
In this form I have a lookup column that has 3 choices: Return To
Inventory, Return To Customer and Scrap/Rework that is based on a table
called "Item"
I want when either Return To Inventory or Return To Customer is selected to
autofill the next field called "ValueOfRework" to 0 but if Scrap/Rework is
selected I want it to fill in the ValueOfRework with the result of 3
previous
entered fields on the form.
FreightCosts+(QuantityReturned*UnitCost)
The result of either selections must show on the form but also be recorded
into the underlying table in the ValueOfRework field.
I know there may be other solutions, but I have the whole thing done and
really don't want to start writing more queries etc. This was just an after
thought that will make entering information into form faster and easier.
After Update of the combo, check for the conditions, then populate as
needed.
It should not require changes to your queries, if I read your statement
correctly, that is.
--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting
From: "Michael Dane" <[email protected]>
Subject: Lookup
Date: Monday, November 29, 2004 11:43 AM
I have a form that is based on a table called "Data"
In this form I have a lookup column that has 3 choices: Return To
Inventory, Return To Customer and Scrap/Rework that is based on a table
called "Item"
I want when either Return To Inventory or Return To Customer is selected to
autofill the next field called "ValueOfRework" to 0 but if Scrap/Rework is
selected I want it to fill in the ValueOfRework with the result of 3
previous
entered fields on the form.
FreightCosts+(QuantityReturned*UnitCost)
The result of either selections must show on the form but also be recorded
into the underlying table in the ValueOfRework field.
I know there may be other solutions, but I have the whole thing done and
really don't want to start writing more queries etc. This was just an after
thought that will make entering information into form faster and easier.