Results 1 to 7 of 7
  1. #1
    bgus is offline Novice
    Windows XP Access 2003
    Join Date
    Apr 2010
    Posts
    8

    broken procedure call to open nested form-?

    The Attendee form has a control button that is supposed to open RegistrationII form. The button doesn't work - am getting "sub or function not defined". Can't figure this out. Thanks in advance for any suggestions.



    (This is an adapted database taken from a template-not all fields are being used)

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    definition errors like this have numerous causes. but to just open a form without arguments, one line is neeeded:
    Code:
    docmd.openform "name" 

  3. #3
    bgus is offline Novice
    Windows XP Access 2003
    Join Date
    Apr 2010
    Posts
    8
    Thank you for that. Still having problem troubleshooting getting the form open.

    My real problem is I had everything working well and then changed the security settings so that the database can't be edited. Then I need to make changes and can't.

    I tried to import the entire db into a new one that has the desired security settings - allowing me to edit in design view.

    BUT the problem of the form calling the one-to-many subform doesn't work.

    If anyone can assist this will be greatly appreciated!!

    Betsy

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Betsy,
    Is this basically a duplicate thread? Can I put the two together for you?

  5. #5
    bgus is offline Novice
    Windows XP Access 2003
    Join Date
    Apr 2010
    Posts
    8
    Yes, I apologize for the duplication (between last night and today).

    I resolved the problem by removing some code for if statements that weren't needed.

    Not sure how to mark resolved but I will try or anyone may feel free to.

    Thank you.

    Betsy

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Follow the link in my sig for directions on marking a thread as Solved.

  7. #7
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Ahh...I see you figured it out already.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 04-13-2010, 12:18 PM
  2. Replies: 2
    Last Post: 02-26-2010, 08:14 AM
  3. Pass a form property to a procedure
    By trb5016 in forum Programming
    Replies: 2
    Last Post: 02-17-2010, 04:15 PM
  4. how to call a sub procedure?
    By dollygg in forum Access
    Replies: 1
    Last Post: 08-18-2009, 05:10 AM
  5. stored procedure return value to access form
    By rbw940 in forum Programming
    Replies: 0
    Last Post: 10-13-2008, 01:31 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums