Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Form caption (change with record?) (2000)

    Is it possible to have the form caption change to reflect the record that is currently selected?
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Form caption (change with record?) (2000)

    Yep, write code in the On Current event of the form, e.g.

    Private Sub Form_Current()
    If Me.NewRecord Then
    Me.Caption = "New record"
    Else
    Me.Caption = "Record " & Me.CurrentRecord
    End If
    End Sub

    You can replace Me.CurrentRecord (the record number) with an expression identifying the record, or whatever.

  3. #3
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form caption (change with record?) (2000)

    Like a charm.
    <img src=/S/hailpraise.gif border=0 alt=hailpraise width=27 height=22> <img src=/S/hansv.gif border=0 alt=HansV width=27 height=26>
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

Posting Permissions

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