List Box Filter

[jeremy0028]

Basically I'm trying to create a list box filter on a form so when user clicks on a patient in the Patient demo tab
Insurances related to the patient will appear on the insurance tab in the list box



I have 2 page tabs on a form one called Patient Demo and the other called Insurances. The Patient Demo reads from the tblPeople And the Insurance tab reads from the tblPeopleInsurance

tblPeople
PersonID(PK Auto#)
LastName
FirstName
MiddleName

tblPeopleInsurances
PersonID(look up)non PK)
InsuranceName(LookUP)
Policy#
Group#

I have a list box on the page tab called Insurances which is called list0 and has the following as the record source

SELECT [tblPeopleInsurances].[PersonID], [tblPeopleInsurances].[InsuranceName], [tblPeopleInsurances].[Policy#], [tblPeopleInsurances].

I tried to create the following qry for the list box also but no luck

I have the following in the query under criteria for the personID

Like "*" & [Forms]![frmPeopleInsurances]![search]
this code give me a parameter query pop up message which
I dont want

SELECT [qryPeopleInsurances].[PersonID], [qryPeopleInsurances].[InsuranceName], [qryPeopleInsurances].[Policy#], [qryPeopleInsurances].[Group#] FROM [qryPeopleInsurances];

Any ideas on how i could create a list box in the insurance tab which links person id to the patient demo tab

 

[dhookom]

What's the pop up message? Are there any subforms involved? What is the exact name of your form and of your list box that displays the persons?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]