Results 1 to 3 of 3
  1. #1
    BernardKane is offline Novice
    Windows XP Access 2010 (version 14.0)
    Join Date
    Jun 2006
    Location
    Lincolnshire
    Posts
    12

    Linking data on forms from one tab page to form on another


    I have a main form with three tab pages. Each page has a form with a sub form. The form uses the same data such as Title, Initial Surname etc but the sub forms look at other tables. How do I link the forms on each tab page so that when a record is selected on the first page it automatically goes to the same record on each of the other pages. Any help would be much appreciated.

  2. #2
    rayc is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Dec 2005
    Location
    Montreal, Canada
    Posts
    19
    Assuming you have a primary key field in your first page (perhaps hidden or something), change the queries behind the two other pages so that they reference the primary key of the first page. Then requery the two other pages when the first page changes record.

    Since each page has a form, you can use the OnCurrent() event of the form. OnCurrent executes when you change record in the form. In the OnCurrent event of the first form, requery the two other forms by using syntax similar to:

    Forms!YourSecondForm!YourFormControl.Form.Requery
    Forms!YourThirdForm!YourFormControl.Form.Requery

    Hope this helps.

  3. #3
    BernardKane is offline Novice
    Windows XP Access 2010 (version 14.0)
    Join Date
    Jun 2006
    Location
    Lincolnshire
    Posts
    12

    Syncronizing Forms

    Thank you I will give it a go

    Bernard

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

Similar Threads

  1. Replies: 0
    Last Post: 11-12-2008, 05:18 PM
  2. Resource for using linking tables with forms?
    By narayanis in forum Forms
    Replies: 5
    Last Post: 05-18-2008, 04:11 PM
  3. Multi Page Forms?
    By Simon Sweet in forum Forms
    Replies: 0
    Last Post: 03-05-2008, 04:01 PM
  4. Linking tables and forms
    By vgatell in forum Access
    Replies: 0
    Last Post: 02-10-2007, 01:37 PM
  5. Replies: 2
    Last Post: 04-11-2006, 08:40 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