Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Macros / May 2008

Tip: Looking for answers? Try searching our database.

opening to a specific record from a listbox control

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Pwyd - 22 Apr 2008 15:03 GMT
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 - 22 Apr 2008 15:34 GMT
I should probably add:  the records are viewed through another form,
[CostpointLog].

> 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
[quoted text clipped - 4 lines]
> Is there a simple way to do this?
> Thanks in advance
Steve Schapel - 24 Apr 2008 10:01 GMT
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.

Signature

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
[quoted text clipped - 4 lines]
> Is there a simple way to do this?
> Thanks in advance
Pwyd - 21 May 2008 20:18 GMT
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,
>
[quoted text clipped - 11 lines]
> > Is there a simple way to do this?
> > Thanks in advance
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.