SubForm ListBox Update question

G

GeoffreyB

Good Morning,

I have a database with the following tables

tblContactInfo
ContactID
FirstName
LastName
tblPresentationInfo
PresentationID
PresentationTitle
Presentation ID
tblContactSelect
ContactSelectID
ContactID
PresentationID

There is a one to many relationship w/enforced referential integrity
(casc. up and down) between the PresentationInfo and ContactSelect
tables. What I'm trying to do is have a subform for the Presentation
where I can select a contact from a listbox tblContactInfo and add it
to another listbox displaying the corresponding Contacts for the
Presentation. I can set up the listboxes to add or delete the
corresponding contacts, but the list box does not update depending on
which presentation I'm in, nor does the list box start as blank when I
create a new presentation- it just lists all the contact information
for all presentations. I tried to set up a relationship between the
subform and parent table with the subform wizard saying that the
PresentationID fields are related between the tblPresenationInfo and
tblContactSelect and my listbox is an unbound listbox that uses a ary
based on the tblContactSelect. Any help on this I could get would be
greatly appreciated. Also, if you need more info let me know. Thanks

Geoff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top