List box help

[d9pierce]

HI, Can someone please help me out?
I am rather new to Access and using access2002! I am creating a db of
clients and contacts. I can do many things but I cannot figure out how
to create a form with a listbox that shows only the contact names of
this form record. I can get them to show all contact names but not just
relating to the companyName in my record.

Can someone show me an example of a form with a listbox that shows only
the related records in that list box relating tot he form? Or tell me
how to do this?

totally lost!

 

[Rick Brandt]

HI, Can someone please help me out?
I am rather new to Access and using access2002! I am creating a db of
clients and contacts. I can do many things but I cannot figure out how
to create a form with a listbox that shows only the contact names of
this form record. I can get them to show all contact names but not
just relating to the companyName in my record.

Can someone show me an example of a form with a listbox that shows
only the related records in that list box relating tot he form? Or
tell me how to do this?

totally lost!

Your ListBox needs to use a query for its RowSource that makes a reference back
to your form.

SELECT ContactName
FROM Contacts
WHERE ClientID = Forms!YourFormName!ClientID

 

[d9pierce]

Thanks Rick,
I sent you an email with a zip file of a db I have been working with to
ask another question