List box help

  • Thread starter Thread starter d9pierce
  • Start date Start date
D

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!
 
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!
Click to expand...

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
 
Thanks Rick,
I sent you an email with a zip file of a db I have been working with to
ask another question
 
Back
Top