Results 1 to 3 of 3
  1. #1
    mreiter is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2011
    Posts
    2

    Link Subform with Replication ID


    I want to link a form and a subform based on a common ID field. I have linked the Master/Child fields and added an event procedure such that when I select a new entry on the master form, the subform updates automatically with the corresponding entries. This works perfectly when the ID field size in both tables is set to Long Integer, but when i try to set the ID field size to Replication ID, the subform is shows up blank. I've tried this for existing tables and also creating tables from scratch. Is there any reason that the Replication ID size should keep a subform from updating properly?

  2. #2
    kennejd is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    188
    Why would you use Replication ID?

  3. #3
    mreiter is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2011
    Posts
    2
    I want to use the replication ID because i have a similar database in SQL (which uses the same alphanumeric format for ID fields) and I thought it would be easier to integrate the data at a later date if I needed to. I realize that the replication ID is not always the most appropriate data type/field size, but I don't see any reason why it shouldn't work just the same.

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

Similar Threads

  1. How to link subform using two fields
    By rohnds in forum Forms
    Replies: 1
    Last Post: 08-04-2010, 04:44 AM
  2. Need help with replication
    By mephisto794 in forum Access
    Replies: 3
    Last Post: 08-02-2010, 08:22 AM
  3. Subform Link Issue
    By danhartman in forum Forms
    Replies: 7
    Last Post: 07-06-2010, 07:14 AM
  4. Replies: 1
    Last Post: 06-14-2010, 03:01 PM
  5. Replies: 1
    Last Post: 03-06-2010, 06:30 PM

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