List Box Question Database Not showing records please Help

[TheViruz30]

Please help me fix my database


If you take a look at the tab called insurance i have a list box. How do i filter the list box so that it will only display the patients insurance based on the demo tab.


Also i have other records in the table called people. they are not showing in the people form. when i use the mouse wheel automatically creates new record please help

 

[bonekrusher]

try this... in your row sourse for the list box

SELECT tblPeopleInsurances.PersonID, tblPeopleInsurances.InsuranceName, tblPeopleInsurances.[Policy#], tblPeopleInsurances.[Group#] FROM tblPeopleInsurances WHERE (((tblPeopleInsurances.PersonID)=[Forms]![frmPeople]![txtPersonID]));