Professional Web Applications Themes

return to previous form - Microsoft Access

I have a Information form with a combo box; if a person isn't in the combo list, it brings up a Add Person Form to fill out. After I have filled the form and executed a DoCmd.Close on the Add Person Form, I need the code to return you to the Information Form, at the combo box I was at when I left, and hopefully do a Me.Refresh to update the combo box. Pia...

  1. #1

    Default return to previous form

    I have a Information form with a combo box; if a person isn't in the combo
    list, it brings up a Add Person Form to fill out. After I have filled the
    form and executed a DoCmd.Close on the Add Person Form, I need the code to
    return you to the Information Form, at the combo box I was at when I left,
    and hopefully do a Me.Refresh to update the combo box.

    Pia


    Pia Jones Guest

  2. #2

    Default Re: return to previous form

    Pia,
    If you open the second form as acDialog:
    DoCmd.Openform "SecondFormName", , , , , acDialog
    it will open on top of the original form.
    Enter your new data.
    When you click the close (X) button, it will close
    and the original form will regain focus.

    No special Close coding is needed in that second form

    Use Me!ComboName.Requery
    in the original form event that opens the second form.

    --
    Fred

    Please reply only to this newsgroup.
    I do not reply to personal e-mail.


    "Pia Jones" <piajonesvideotron.ca> wrote in message
    news:%C5Ma.13885$U02.296671wagner.videotron.net.. .
    > I have a Information form with a combo box; if a person isn't in the combo
    > list, it brings up a Add Person Form to fill out. After I have filled the
    > form and executed a DoCmd.Close on the Add Person Form, I need the code to
    > return you to the Information Form, at the combo box I was at when I left,
    > and hopefully do a Me.Refresh to update the combo box.
    >
    > Pia
    >
    >

    Fredg Guest

Similar Threads

  1. Next/Previous buttons in Search form
    By wanna_learn in forum Coldfusion - Getting Started
    Replies: 8
    Last Post: September 15th, 02:49 AM
  2. return to previous
    By Eside in forum Macromedia Dynamic HTML
    Replies: 1
    Last Post: September 1st, 04:54 AM
  3. Populate form values based on previous same form fields
    By Rizyak in forum PHP Development
    Replies: 2
    Last Post: June 11th, 04:27 PM
  4. Newbie: Why doesnt this form return a value??
    By Blobby J Blobdom in forum PHP Development
    Replies: 1
    Last Post: October 16th, 10:14 AM
  5. "back" and return to previous place script?
    By Rob Dillon in forum Macromedia Director Basics
    Replies: 5
    Last Post: September 5th, 07:26 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139