I have 2 text boxes and a query on a form called "Adjustment Form"
[Text box A] is for volume adjustments, [Text box B] is for volume adjustment %'s.
The query (Q2b) always contains a single record with 4 columns: "Actuals", "Active Volume", "As Sold Volume", and "Revenue".
I would like to set up the "On Exit" event for "Text Box A" so that when you exit the text box it sets the value of Text box B to be = [Text Box A] / "As Sold Volume" from query Q2b.
I'd also like to set up the "On Exit" event for "Text Box B" so that, when you exit the text box, it sets the value of Text box A to be = [Text Box B] * "AS Sold Volume" from query Q2b.
I'm an Access Novice. I've set up "clear" buttons for both boxes with the simple line Me.TextBoxA.Value = 0 and the same for B.
Where I'm stuck is referencing the query results in the value. Any help?
[Text box A] is for volume adjustments, [Text box B] is for volume adjustment %'s.
The query (Q2b) always contains a single record with 4 columns: "Actuals", "Active Volume", "As Sold Volume", and "Revenue".
I would like to set up the "On Exit" event for "Text Box A" so that when you exit the text box it sets the value of Text box B to be = [Text Box A] / "As Sold Volume" from query Q2b.
I'd also like to set up the "On Exit" event for "Text Box B" so that, when you exit the text box, it sets the value of Text box A to be = [Text Box B] * "AS Sold Volume" from query Q2b.
I'm an Access Novice. I've set up "clear" buttons for both boxes with the simple line Me.TextBoxA.Value = 0 and the same for B.
Where I'm stuck is referencing the query results in the value. Any help?
