My total is calculated with the expression
Private Sub Rate_AfterUpdate()
Me.Total = Me.Quantity * Me.Rate
End Sub
After Rate is updated in Rate text box Total is calculated with above expression.
For Discount I want to update the Discounted amount after discount percentage is given by the...
I am trying to calculate discounted amount in text form. I have Rate Quantity and Total, where i can calculate total amount in text box. Now I want to calculate Discounted amount in another text box after user inputs discount percentage. Any suggestion please
Hi, I did as per your advise but the data is not saved in table instead a blank row is created with no data in the field. The form goes blank but data is not saved in table.
Hi, I am working on a table that I want to update using form. I want to use that form to insert record in the table. The table is bound with the form. My problem is that once I save the record the form still has the text that i entered which i want to be cleared once i click on Save button. I...
Hi, I am Ashes Timsina from Nepal and I am new to access programming. I am looking forward for a productive discussion and sharing of ideas in the forum.
Thank you