opening to a specific record from a listbox control

[Pwyd]

Simple i should think: i have a listbox control [List94] on a form named
[Batch Status Page]. I'd like to set the event procedure to allow me to
double click on any of the records listed in the listbox (there are four
columns. the first column holds the batch number, which is associated with
the record number).

Is there a simple way to do this?
Thanks in advance

 

[Pwyd]

I should probably add: the records are viewed through another form,
[CostpointLog].

 

[Steve Schapel]

Pwyd,

It is not clear what you want to do. Can you give an example please?
What is the Bound Column of the List94 listbox? Normally using the Dbl
Click event of a listbox is an unwise idea. The After Update event is
often a good choice.

 

[Pwyd]

The idea became not-so-useful due to some other circumstances. What i wanted
was, at first, to open a subform that showed other relevant data to a record
being listed only by its name and batch in a listbox. Instead of querying
that data and building a subform, i figured i could just have it open up a
single-filtered database containing the record i was looking for.

Pwyd,

It is not clear what you want to do. Can you give an example please?
What is the Bound Column of the List94 listbox? Normally using the Dbl
Click event of a listbox is an unwise idea. The After Update event is
often a good choice.

--
Steve Schapel, Microsoft Access MVP

Simple i should think: i have a listbox control [List94] on a form named
[Batch Status Page]. I'd like to set the event procedure to allow me to
double click on any of the records listed in the listbox (there are four
columns. the first column holds the batch number, which is associated with
the record number).

Is there a simple way to do this?
Thanks in advance