Access form with a subform - Unbound Listbox selection to update bound Customer Name used by subform
Posted on 2011-05-07
I will show my stupidity of Access and VBA again with another question.
I have a series of queries that gets me to a summary of costs by Job and Job Cost Item. I am creating a form that has a subform where the total costs on the Job To Date show as totals on a subform.
The main form is where the user selects which Job they are reviewing. the Link Master and Child between the Main form and the Subform are Name
Instead of just using the navigation buttons to scroll from job to job I want the user to be able to select the job from a Listbox.
Using Access 2007 I created the Form and Subform and it brought the Field Name as a bound item on the form. I then added an Unbound Listbox where I want the user to be able to select the Name from the list let it update the bound box [Name] and update the contents of the subform.
My unbound list box name is "lstJobCostSummaryJobSelector"
The bound items on the main form are:
The subform is "sfrmJobSummaryItemGroupDetail"
My Row Source for the "lstJobCostSummaryJobSelector" is
SELECT [qryQBCustomer].[NAME], [qryQBCustomer].[REFNUM], [qryQBCustomer].[Active Status T/F] FROM qryQBCustomer;
How do I get the bound item [Name] to update with the item selected in the list box?