Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2009
    Posts
    28

    Red face Unanswered: Access 93 :- Form Problem

    I have a Form A which calls a SubForm B.
    Form A has a field which needs a drop down, but doesn’t have it at present.
    Conversely, SubForm B has a field which has a drop down, but shouldn’t.
    I can access SubForm B, go to design mode, select Properties,
    and reset fields ‘Enter Key Behavior’ to ‘Default’
    ‘Scroll Bar’ to ‘None’ and
    ‘Tab Index’ to 2.
    I then get prompted whether I wish to save changes, and when entering “YES” am taken out of the SubForm, and the changes are saved OK.
    However, when I try to amend Form A, I cannot save the changes.
    I set ‘Enter Key Behavior’ to ‘NL in Field’ ‘Scroll Bar’ to ‘Vertical’ and
    ‘Tab Index’ to 2.
    But when I enter “YES” to the save change prompt, I am not taken out of the form.
    No matter how often I select the X and then enter “YES”, the form keeps displaying.
    The only way to get out is either to enter “No”, or to quit via Task Master.
    Either way, the change is not saved.
    Permissions must be OK else I wouldn’t be able to amend the subForm.

    Are there further things to watch out for with a calling form ?

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Sounds like corruption to me.
    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
    Jul 2009
    Posts
    28
    You were right : I re-started from scratch, and all is well now. Many thanks

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Keep good backups so that if anything disastrous happens, you can recover without having to re-design.
    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
  •