Display all rows containing same contactid only.

[siliconfiber]

Access newbie.... that being said!!

I am trying to display in a list box only the rows matching the current "contactid" field being displayed in the form that is active. Would this be a query and what would the code behind it be.



Thanks in advance.

[June7]

All this is on the same form? This would be an SQL Select statement in the ListBox RowSource property that references the ID field of the current record.
SELECT fieldname FROM tablename WHERE ID=Forms!formname![ID]
Then need code (I use VBA but suppose macro could do this) in the form's OnCurrent event to requery the listbox when navigating between records of the form.
Private Sub Form_Current()
Me.listboxname.Requery
End Sub

An alternative is a subform instead of listbox. The Master/Child link properties of the subform container control would synchronize the records. No code required.

[siliconfiber]

Thank you for the help, just getting back to this... it worked just fine.