Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Location
    CT,USA
    Posts
    250

    Unanswered: matching a subform record to mainform field1

    I'm trying to use a single record subform to match a field on the main form which also displays a single record (not continuous). My matching field name is UserNTID, and the matching subform name is OwnerNTID. I suspect I need some code in OnCurrent. I have tryed to turn the filter on the subform in the main form's OnCurrrent (also setting subforms FilterOn = true), but have been unsuccessful. I'm sure it is something easy, though I haven't worked with subforms much. Please, help.

  2. #2
    Join Date
    Mar 2004
    Location
    Berlin, Germany
    Posts
    107
    what about using "Link Child/Master Field" of the SubForm container .. no code needed

  3. #3
    Join Date
    Nov 2003
    Posts
    1,487
    I agree with bachatero. For your particular application, utilizing the Link Child Field and Link Master Field properties of the SubForm would be the easiest way to go.

    Simply place OwnerNTID into the Link Child Field property of your SubForm control, and place UserNTID into the Link Master Field property of your SubForm control.


  4. #4
    Join Date
    Feb 2004
    Location
    CT,USA
    Posts
    250
    Thanks a lot. That was as simple as I was hoping it to be. Yahoo!

Posting Permissions

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