Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Navigation controls (XP)

    I am working on some forms and trying to make them look better & be more

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

    Re: Navigation controls (XP)

    You can place a textbox on the form with control source

    ="Record " & [CurrentRecord] & " of " & [RecordSet].[RecordCount]

  3. #3
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Navigation controls (XP)

    Thank you Hans, perfect solution.

  4. #4
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Navigation controls (XP)

    A follow-up question. I am dealing with sub forms that have a parent child relationship with the main form. In other words, the main form may show 5 records but each of those 5 records may have several "sub records". For example, Job 1 has A, B, C, D, and E sub jobs. In total, the 5 main records (jobs) contain 25 sub records (sub jobs). I would like for my sub form to display 1 of 5 but instead, it shows 1 in 25, 2 in 25, etc.

    Is there a way for me to limit the record count to only those records within a "family"?

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

    Re: Navigation controls (XP)

    If I link the subform correctly to the main form, the number of records in the subform is displayed correctly; it is updated automatically when I move to another record in the main form. However, the current record number in the subform is not kept up to date; this can be remedied by putting an invisible unbound text box on the subform, and putting code in the On Current event of the subform that sets the value of this textbox to Me.CurrentRecord. This forces Access to keep track of CurrentRecord in the subform.

  6. #6
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Navigation controls (XP)

    Quite right. I realize now that I was looking at the form in isolation - it does work correctly. Sorry about that.

Posting Permissions

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