Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2011
    Posts
    47

    Unanswered: Need help with a field in a form!

    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!
    Last edited by rasghar; 07-10-11 at 10:55.

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    I've answered this for you elsewhere, but on the off chance that someone searches this forum for this kind of thing, I'll post it here as well!

    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.
    Code:
    Private Sub FeeEarner_AfterUpdate()
       Me.FeeEarner.DefaultValue = """" & Me.FeeEarner.Value & """"
    End Sub
    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •