setting the default value as another feild in form

[djwasim]

how can i set the default value of a field as another field in a form?

wasim shahzad
Pakistan

 

[hiền muội]

You mean, when you type a value in field1, field2 have value as field1?

 

[djwasim]

actually there is a form named purchasefrm having fields
item
description
units
quantity
price
value
averageprice

now when i enter a itemcode and quantity then price should be same as averageprice automatically. how is possible?

 

[hiền muội]

Use Event BeforeUpdate for txtPrice to calculator averageprice.
Example:
Private Sub txtPrice_BeforeUpdate(Cancel As Integer)
Me.txtAveragePrice=...
End Sub

 

[djwasim]

i don't get any result from this event.
plz any one tell me in detail.

 

[djwasim]

plz any one help me