B
Bob Wickham
Hi,
This sounds really easy, but ........
I have a form/sub-form.
The Record Source of the sub-form is
SELECT tblCommission.LoanNo, tblCommission.PaymentDate,
tblCommission.Payment, tblCommission.GST, tblCommission.DateBanked
FROM tblCommission;
I want the value in the GST text box to be calculated and shown as soon
as the user enters a value in the Payment text box.
GST is a tax and is always 10%.
So, if $10.00 is entered into Payment, the value $1.00 will be
immediately entered into GST but this should be able to be over-ruled by
the user.
Do I alter the Record Source with a WHERE GST = Payment * 0.10 type of
thing or is it a case of some code in an Event.
Before I spend many more hours on this can anyone offer some advice as
I fear I am going about this very wrong.
Thanks.
Bob
This sounds really easy, but ........
I have a form/sub-form.
The Record Source of the sub-form is
SELECT tblCommission.LoanNo, tblCommission.PaymentDate,
tblCommission.Payment, tblCommission.GST, tblCommission.DateBanked
FROM tblCommission;
I want the value in the GST text box to be calculated and shown as soon
as the user enters a value in the Payment text box.
GST is a tax and is always 10%.
So, if $10.00 is entered into Payment, the value $1.00 will be
immediately entered into GST but this should be able to be over-ruled by
the user.
Do I alter the Record Source with a WHERE GST = Payment * 0.10 type of
thing or is it a case of some code in an Event.
Before I spend many more hours on this can anyone offer some advice as
I fear I am going about this very wrong.
Thanks.
Bob