Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    9

    Question Unanswered: Storing copy of a mainform field value in subform table

    I have a mainform with a field called DeptID, which is a listbox. How can I store the value selected for DeptID in mainform, under the table used by subform. There is a field called PDeptID in subform table which needs to hold this value.

    I have tried referencing the mainform field in subform, by using [Parent]![DeptID] under control source, but it doesn't seem to work.

    Any help is appreciated.
    Thanks

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    What is the relationship between your mainform and the subform? I don't undestand why the same value would need to be placed in two tables..

Posting Permissions

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