Default Value In a field

[djwasim]

how can i set the default value of a field (before entering any any value) as another field in a form? For example there are 4 fields named

Quantity---Price---Amount---Avgvalue

now i use to enter data as.........

Quantity---Price---Amount---AvgValue
---5--------20------100--------20---
---4--------20------80---------20---
---3--------20------60---------20---
(Where the "avgvalue" is calculated automatically by "DAvg" formula)

Now when i have no price but enter only quantity in field then the price should be "Avgvalue" by default.

how is it possible?

any one help me plz.........

dj wasim shahzad
Pakistan

 

[khawar]

You can set this in the default value property of control

 

[djwasim]

i do that but no result found

I am sending you the dbs plz check it and tell me
there is problem in purchase form plz check it

 

[khawar]

Check the attached file

 

[djwasim]

Ohh thanks alot
thank u sooooooooooo much.