calculate discount and gross margin in form

[tommyried]

hello everyone,

i want to calculate discount and gross margin on a form based on percentage can anyone provide me the code for the attached database.

thanks

[Bob Fitz]

Can you post a copy in A2003 mdb format.

[tommyried]

hi bob,

please find attached in mdb format.

[tommyried]

hello everyone

please its very urgent can anyone help me on attached database ,I have cost price on a form for different items first I want to automatically calculate discount on the cost price then apply gross margin in percentage.

Notepen the attached database in form view

[Bob Fitz]

Not sure of the calculation to be made, but maybe something like the attached db:

[tommyried]

thank you very much bob for your support.

[Bob Fitz]

thank you very much bob for your support.

You're welcome, but does the expression supplied give the correct results.

[tommyried]

dear bob

its ok but now I have added one new command button called CLEAR which will clear the type in values but for the text box which we are having an expression cannot be cleared iam using the vba code something like this but its giving me error.

Private Sub Command33_Click()
Me.Text22.Value = ""
Me.Text24.Value = ""
Me.Text29.Value = ""

End Sub