Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Mar 2002
    Posts
    132
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a form with single select listbox (LAreas). The listbox filters the records that show in my subform (LTests). So each LArea has many LTests. I want the user to select a LAreas and be able to add a LTests (numeric). Sometimes the user adds a new LTests and forgets to add the LAreas. Is there a way to add the LAreas (from lstboxLAreas) when a new LTests is inserted.

    Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    If you set the Link Master Fields property of the subform to the name of the list box and the Link Child Fields property to the name of the corresponding field in the subform, Access will automatically fill in the value of LAreas in new records in the subform.

Posting Permissions

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