Results 1 to 4 of 4
  1. #1
    Join Date
    May 2009
    Posts
    7

    Unanswered: Go to record based on value in a textbox

    I have a combobox (lists years) inside a subform. When a year is selected for the current member, it should go to the record where combobox year = table year.

    The subform is of a table named [Thank You Letter] consisting of Member ID (PK), Academic Year (PK), Thank You Letter. Year is a number and thank you letter is a checkbox.

    ex)
    Say there are 5 total records in a subform for a member. By default, 1 of 5 is displayed in the record navigation menu. When i choose a year from the drop down box, the current record should change to the record where [Thank You Letter].[Academic Year] = " & Me.[Academic Year].

    So if i chose 2006 in the combobox, 3 of 5 was then displayed in the record navigation menu. I am just concerned with going to a record based on the combobox value.

    I'd appreciate any help as i'm having no luck finding a solution.

    Thanks

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14

  3. #3
    Join Date
    May 2009
    Posts
    7
    I did that to but i keep getting the following error when i change the date:

    "Update or CancelUpdate without AddNew or Edit"

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Then that is what you need to resolve. There is no Update or CancelUpdate in the code linked to. Find out what is generating that error and correct it.
    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
  •