opening to a specific record from a listbox control

  • Thread starter Thread starter Pwyd
  • Start date Start date
P

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,

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.
 
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.

Steve Schapel said:
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
Click to expand...
Click to expand...
 
Back
Top