Listbox selection displaying on subform

[gjameson via AccessMonster.com]

I have a listbox that I used to search for a customer, either by an ID or
narrow the listbox down to a name search.
The list box is unbound.I am using Select DistinctRow to find my data. This
works great.

I would like to be able to click on a list box entry and have maint records
displayed in a sub form below the list box. I have tried all kinds of
combinations. The list is unbound and the subform is bound to a query. I have
tried setting the Child to my Subform and Master to my listbox. Nothing is
showing up. What am I missing here?

Thanks in advance.

Gerald

 

[jahoobob via AccessMonster.com]

The Master/Child link is by fields. You will need a field that is common to
your main form and subform. The maint records should have a link to the
customer records such as a customer ID #. When you open the properties of
the subform in the form and click the ellipsis (...) on Link child fields or
the Link master fields, you should be presented with drop downs with the
available choices.

 

[gjameson via AccessMonster.com]

I understand how this is supposed to work. But it is not.

I beleive it might have something to do with the listbox being unbound. The
list box is unbound.I am using Select DistinctRow to find my data.

The field on my form are two text fields used to search for customers in the
listbox and the subform where I want the associated recoreds for each
customer. Any other ideas?

The Master/Child link is by fields. You will need a field that is common to
your main form and subform. The maint records should have a link to the
customer records such as a customer ID #. When you open the properties of
the subform in the form and click the ellipsis (...) on Link child fields or
the Link master fields, you should be presented with drop downs with the
available choices.

I have a listbox that I used to search for a customer, either by an ID or
narrow the listbox down to a name search.

[quoted text clipped - 10 lines]

Gerald