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.
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