Results 1 to 2 of 2
  1. #1
    vCallNSPF is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Dec 2009
    Posts
    49

    Import value from one form to another

    I have three forms.



    One is for a piece of equipment with all of its information, eg. location, frequency, type, id number etc.

    The second is for tests on that piece of equipment.

    The third is for calculating whether the battery needs to be replaced or not.

    The second and third form have a relationship to the first form via an equipment identification code. eg. Display One's id code is D1.

    The first form will have two buttons linking to the test form and battery form. Is it possible to automatically import the value of the identification code field from the first form into the identification code field of one of the other forms once you click one of the buttons.

    thanks

  2. #2
    ConneXionLost's Avatar
    ConneXionLost is offline Simulacrum
    Windows XP Access 2003
    Join Date
    Jan 2010
    Location
    Victoria, Canada
    Posts
    291
    Hi vCallNSPF,

    Yes. Although what you describe sounds like an ideal situation to set up your test and battery forms as sub-forms of the equipment form. If you did this then the ID code field would be established via the master-child form relationship.

    The sub-form control has a wizard that should walk you through the process fairly smoothly. The Tab control may also help if you need room on your equipment form.

    Cheers,

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

Similar Threads

  1. Import a totals value
    By vCallNSPF in forum Access
    Replies: 5
    Last Post: 12-13-2009, 07:01 PM
  2. import custom form data from Outlook
    By bigsteve520 in forum Import/Export Data
    Replies: 0
    Last Post: 11-13-2009, 12:18 PM
  3. CSV vs XLS Import
    By Betty Boop in forum Import/Export Data
    Replies: 1
    Last Post: 10-27-2009, 07:10 AM
  4. How would I import something like this?
    By Insyderznf in forum Import/Export Data
    Replies: 13
    Last Post: 08-10-2009, 05:18 PM
  5. CSV File Import
    By compasst in forum Import/Export Data
    Replies: 3
    Last Post: 03-31-2006, 09:37 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