Results 1 to 2 of 2
  1. #1
    ETCallHome is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Mar 2011
    Location
    Limpopo, South Africa
    Posts
    48

    Identifying which Form call another Form

    Hi,



    I need to identify when a Form1 is opening from another Form2, is there anyway that Form2 knows that Form 1 open it. The reason why I need to know is that I have a form that allows the user to input search critieria. The user is then allowed to either enquire/modify/delete a record. I created command buttons and on click it opens a form2. Form2 has the same layout for all the command buttons, but of enquire is clicked, then I want to disable all the fields, when modify is clicked then enable the fields. Or is there a better way to do this function...

    Your urgent assistance is highly appreciated.

    Thanks
    Earl

  2. #2
    thhui is offline Competent Performer
    Windows XP Access 2002
    Join Date
    Feb 2009
    Posts
    235
    See this link
    http://www.datawright.com.au/access_..._arguments.htm

    In frm1st, open frm2nd
    DoCmd.OpenForm "frm2nd", acNormal , , , acFormEdit, , Me.name


    In frm2nd,
    Me.OpenArgs is the frm1st's form name

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

Similar Threads

  1. Identifying Changed Fields in Two Tables
    By novice in forum Queries
    Replies: 1
    Last Post: 12-16-2010, 05:43 AM
  2. Replies: 2
    Last Post: 11-30-2010, 10:06 AM
  3. Identifying the first entry
    By HelenP in forum Access
    Replies: 8
    Last Post: 10-20-2010, 08:31 PM
  4. Identifying new data
    By manicamaniac in forum Programming
    Replies: 5
    Last Post: 04-28-2010, 11:08 AM
  5. Replies: 6
    Last Post: 04-24-2010, 11:12 AM

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