selecting an entry in listbox, show record

[kRiX]

I am trying to come out with a function that when you have selected an entry
in the listbox, it will open up another form with the relevant details
pertaining to the entry in the listbox. As in my listbox field will be
Company. And when i click on like ABC company, it will show the relevant
details of the company like date and time for visit to customer site? It can
also be on the same form.

I tried doing that but got multiple entries for the company in my record if
i put another record in the subform. Any suggestions?

 

[Klatuu]

Your post is somewhat confusing, but a couple of things should be considered.
First, is there any specific reason you are using a List Box for this? If
you are selecting only one company, the Combo Box is a much better control to
use for locating a specific record. List boxes are great when you need to
allow the user to make multiple selections or when you want to display
multiple columns all the time.

The most common technique is to use the After Update event of the combo box
to locate and present the selected record.

This sentence really confused me:
"> I tried doing that but got multiple entries for the company in my record
if

i put another record in the subform. Any suggestions?"

You don't get multiple entries in one record, and what do you mean by "put
another record in my subform"?