Populate Details in SubForm

[ragu111]

i have made a contact list in access. with two tables

Table1 have the company name and Head_ID
Table2 have contact details

both Table linked with Head_ID and Details_ID

on the form i want to display all the company name one side on a ListBox. otherside i have the subform with contact details.

what i want is, when i ckick the company name in ListBox, subform should show the contact details for the selected company.

ragu

 

[Remou]

Hi
You can use the After Update Event:

Private Sub [i]ListBoxName[/i]_AfterUpdate()
Me.[i][ContactDetailsSubformControlName][/i].Form.RecordSource = "Select * From [i][ContactDetailTableName][/i] Where  Details_ID = " & Me.[i]ListBoxName[/i] 
End Sub

The above is for numeric link fields, if the link fields are text, you need:
='" & Me.ListBoxName & "'"
Your list box must have Head_ID as the Bound Column.

 

[ragu111]

tks remou,

i tried but i'. getting an error. below is my code

Private Sub Head_List_AfterUpdate()

Me.Head_id.from.RecordSource = "select * from details where head_id = " & Me.Head_List

End Sub

ragu

 

[Remou]

Hi
If this is a cut and paste, there is a typing error:
Me.Head_id.[red]from[/red].RecordSource
This should be form:
Me.Head_id.form.RecordSource