Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2008
    Posts
    25

    Unanswered: clicking through from record to record on form

    I have a bound form which is used for inserting records and viewing existing records. If I open an existing record I want to be able to click the forward and back buttons at the foot of the form to move from record to record, how can I do this???

    I didnt build the form and have limited access from experience. Presently when I open a record I do see:

    Record: (back arrow) and (forward arrow)

    on the bottom however the back button is grayed out and I am only allowed to clik forward which clears the form and alllows me to enter a new record only.

    TYIA

    -----------------updated info:
    I have been researching this and am fast coming to the conclusion a bound form can not use the record navigation, or at least this one cant. SHould I be able to???

    May I add this to the scenario - When I open the form as if I am entering a new record the navigation works. However if I open an exisitng record it does not. I have even turned off the navigation and using controls created my own. This also works and fails in the same way described.

    Any ideas???
    -----------------------------
    Last edited by mat41; 01-06-09 at 21:58.

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    It is normal for a bound form to be able to navigate through data.

    Yours is either set to Data Entry: Yes (my guess as to what's wrong), or your form has code in it to disable certain activity.

    Go to your form's properties and make sure the Data Entry property is set to No.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Dec 2008
    Posts
    25
    Thank you for your time. This property is set to No, any other ideas??

    I have been trying to solve this for three hours now, aggghhhh....

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Check the code in the form?

    Rebuild the form?

    Bit hard to know with such limited information on what you have.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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