I have a database with a Contact table and a Phone table. The phone table has a pointer to the Contact table's internal ID. There may be zero up to an unlimited number of phones for each contact.
It seems that the "List Box" should be the way to display, but I can't figure out how to use the wizard or otherwise configure it so I get the list of nmbers associated with each contact as I bring them up.
Kevin Robertson
@Reply 3 years ago
After you create your List Box edit the Row Source to show only the phone numbers for the current contact. You will also need one line of VBA code to requery the List Box as you move from record to record. See screenshot below.
Kevin Robertson
@Reply 3 years ago
James SwansonOP
@Reply 3 years ago
Thank you. I realized I was using the wrong tool. I used the form wizard and implemented a subform. Turns out it is quite useful!
I will use your example, though, for other things I need to accomplish.
Best Regards,
Jim
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access TechHelp.
