Results 1 to 2 of 2
  1. #1
    Kiley is offline Novice
    Windows 7 64bit Access 2013 32bit
    Join Date
    Jun 2016
    Posts
    28

    Set default header in new form from button on previous form

    I have a customer search form (user types customer name and all matches populate in subform below). On this form i have a 'new activity' button that, when a user clicks, i would like for it to open an activity window to make notes on a policy, if it cancelled/reinstated/etc. i would like for the user to be able to select from the search form, the record that has the insured name on it, and then once they click the 'new activity' button, to have that activity form open with the insured name prefilled in the header of that form so that they do not need to type that in again.

    Novice user, slowly learning. Thanks in advance for any help!! Greatly appreciated

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    If it's opening to an existing record:

    BaldyWeb wherecondition

    If you're going to add a new record:

    DoCmd.OpenForm...
    Forms!SecondFormName.TextboxName = Me.TextboxName
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Sort button in the Form Header
    By trident in forum Reports
    Replies: 2
    Last Post: 04-21-2015, 07:12 AM
  2. Button to have same data as previous form.
    By ryanmce92 in forum Forms
    Replies: 8
    Last Post: 01-14-2015, 02:49 AM
  3. Replies: 1
    Last Post: 05-31-2013, 08:53 AM
  4. Replies: 3
    Last Post: 10-22-2010, 06:53 PM
  5. Replies: 4
    Last Post: 01-27-2010, 12:39 PM

Tags for this Thread

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