Results 1 to 2 of 2
  1. #1
    lfox is offline Novice
    Windows 7 Access 2007
    Join Date
    Jun 2010
    Posts
    7

    Subform's date field populates from main form's field

    I'm hoping someone can help. I have a main form called "361" with multiple subforms. The main form and each subform have date fields. The master form's date field will be entered by the user. I'd like the subform's date fields to be hidden and populate without any interaction by the user.



    The date field on each subform is linked to it's respective table. What I can't seem to figure out is how to get the date field on the master form to populate into each subform's table. Any ideas would be greatly appreciated.

  2. #2
    lfox is offline Novice
    Windows 7 Access 2007
    Join Date
    Jun 2010
    Posts
    7
    I figured this out within minutes of hitting "submit reply". I apologize. I simply made the default values of the subform fields = that of the main form and it works perfectly.

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

Similar Threads

  1. Replies: 3
    Last Post: 11-05-2010, 03:10 PM
  2. Update field in subform from field in Main
    By jpkeller55 in forum Access
    Replies: 9
    Last Post: 10-15-2010, 03:37 PM
  3. Set date field on subform to date variable
    By laavista in forum Access
    Replies: 4
    Last Post: 06-30-2010, 06:32 PM
  4. set date field on form to date variable
    By laavista in forum Access
    Replies: 3
    Last Post: 06-28-2010, 03:03 AM
  5. Replies: 10
    Last Post: 04-21-2010, 01:16 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