list box of related records

[icccapital]

I have a form with contact information that is pulling from one table. This
table is related to another table (clients) by the id number and in the
clients table there are multiple client codes that relate to each contact
ids. I would like to have a list box on the side of my contact information
that contains the related client codes and be able to add and remove client
codes, which would affect the clients table.

I have seen that this can be done with a subform, but it seems a bit unruly
and excessive. Can it not be done with just a list?

 

[Klatuu]

It could be done with a List Box, but a subform is actually much easier. A
subform is intended for this sort of use. To use a List Box, you would need
to do a lot of VBA coding to be able to delete records and manage the list.
You can't create a new record using a list box, you would have to have
another control for that. For you and your users, stick with a subform.

 

[icccapital]

Ok, thanks for the response. Sounds like the excess would be in doing the
list box, so I will stick with the subform and mess with it.

 

[Klatuu]

Good Luck. If you have any problems with it, these newsgroups are a great
source of help.