Event procedure for default value of subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to make an event procedure on a field in a subform to say that
if the data in a field in another subform is x then default value should be x
but if data in field in another subform is y then default value should be y
etc

Please help

Thanks!!
 
Hi,
yes, you can.
you can either use Current Form event, or "field in another subform"
AfterUpdate Event to set field default value.
Like:

me.MyOtherField.DefaultValue = Me.MySubformControl.Form.MyField
 
Back
Top