Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005
    Posts
    18

    Unanswered: Newbie help! Open Form and Subform via Listbox Selection?

    Hi everyone, this is my first post so I hope that my question isnt too silly to answer!!...

    I have a main form (search_form) with a listbox (lst_search).

    I want to select a record - eg number record #1 from the user_id field (column 0) of list_search so it opens another database form called "address_form" and its linked subform "user_subform" to show the selected record from the listbox(user_id).

    The problem is that the field user_id which I select from the listbox is on the subform (user_subform), not the form (address_form).

    How do I get both the address_form and user_subform to open with the correct record showing in the user_subform?

    I hope I have explained that clearly! I know I can just create new forms and subforms so that USER is the form and Address is the Subform, but that will cause further trouble later on.

  2. #2
    Join Date
    Jan 2005
    Posts
    18
    Ive found out how to do it I had to add an extra field to the query which the listbox was using as its record source. The extra field linked the address_form to the user_id and thus to the listbox user_id

Posting Permissions

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