DblClick items in Unbound List Box

[Mark Roberts]

I have a table (no primary key) TopicID, Topic and Topic
Title. I have created a form with an unbound list box that
opens with the list of Topic Titles. I want to DblClick on
a title from the list and open the Topic. I am lost. Or
maybe just having brain f..."you know whats". Does anybody
have a solution?

 

[Larry Linson]

"Open the topic"? Do you mean locate the record and populate the form with
its data? If so, the Combo Box wizard will write the code for you. Give that
a try. You can use the "Limit to List" property to prevent the user entering
non-existent values.

Larry Linson
Microsoft Access MVP

 

[Mark Roberts]

Larry,

Thank you for your help. But I'm not sure I was clear in
my description. Here is a Word document that contains the
data I am using in the table. I have created a form with
an Unbound list box for the "Topic Titles", which when
opened displays the entire list of titles with a vertical
scroll bar to scroll through the list. What I want to
accomplish is to DblClick on a title in this list and open
the related topic for that title on another form. I have
created separate forms for each topic, but don't know how
to click a title and have it open that topics' form.

I have tried putting the unbound "titles" list and
a "topics" sub-form on the same form. And it works like
you said. When I click a title, that topic opens in
the "topics" sub-form. But the formatting of the text in
the sub-form is horrible. All of the sentences run
together and all of my bullets, etc are gone. What else
can I try? I appreciate you help and patience.

Mark Roberts
(e-mail address removed)