Subform based on a list box

[HowHow]

In Access 2000, I created a blank form. In the form I have a list box on the left and subform on the right. I need the subform to show the data based on the name that I click/ highlight from list box. Meaning everytime I click on a different name from the list box, the subform should show the related data only. I need to be able to modify, add or delete my data from my subform. How to do that?

The list box is based on the query to get a name list from my table named T_ContactDetail. The subform is based on the table T_ContactDetail. Is it possible to do it in the form? or do I need a function to do that?

[nico5038]

You'll only have to use the linkage fields of the subform.

Make sure that the "bound" column of your listbox points to the unique ID used in your subform.

Now single-click the subform when in designmode and activate the properties window. Under the Data tab you'll find two "linkage" fields, one Master and a Child.
Enter the name of the listbox in the Master and the name of the subform's unique key in the Child linkage field.

Nic;o)

[HowHow]

Hi Nico,

Thanks a lot!
At first I misunderstood but now I got it. I must set the bound column to 2 even thought I am showing [Contact Name] only in the list box. Then using your method to get the info. Thanks.

[nico5038]

Glad to see you've found it :-)

Success with the application !

Nic;o)