Need help with a field in a form!

[rasghar12]

Hi,

I have a form(frmLegalAid), its default view is Continuous Form.

I have a field called Fee Earner in a combox, i need some way of the value in the fee earner combox to automatically be transferred to the new combox when a new record is made.

Is there anyway of doing this?

If you need any more info, please ask!

Thanks in advance for any help!

 

[missinglinq]

In your form, you can use the AfterUpdate event of the control holding your data to set the DefaultValue for the field. From that time forward, until you either manually change the data or close your form, the data will be entered automatically in each new record.

If your Control is actually named Fee Earner, with the space (considered a bad practice, by the way)

Private Sub Fee_Earner_AfterUpdate()
   Me.Fee_Earner.DefaultValue = """" & Me.Fee_Earner.Value & """"
End Sub

Linq ;0)>

 

[rasghar12]

Hi missinglinq,

Thats great, works perfectly! thanks

btw, the field is called cboFeeEarner not fee earner so i should be fine


Thanks for the help

 

[missinglinq]

So replace Fee_Earner in the code with FeeEarner

Glad we could help!

Linq ;0)>