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 / Modules / DAO / VBA / January 2007

Tip: Looking for answers? Try searching our database.

how can i use a list box and command buttons

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
kr - 31 Jan 2007 01:05 GMT
I have a DBS that has records in it that employees call.    I have created a
form in which they input the data from the call.  Some records have multiple
telephone numbers.  What I would like to do is on the form have a list box to
show all of the telephone #s.  To the side I would like to have buttons that
would correspond to the highlighted number.  For instance, if a # is bad, the
employee would highlight the # and then click the "Bad#" btn and it would
delete the # and paste it somewhere else with the words "Bad Number" next to
it.  Same would be true if a # was disconnected, wrong, so forth.  What is
the easiest way (if there is one) to create this and do it?  Would I have to
I have to make a subform for this?
Sreedhar - 31 Jan 2007 03:04 GMT
Hi kr,

Yes, a sub-form is the answer. You can have a field "NumberStatus" next to
the # field, and you can use a combo for updating the status of a #. The
obvious advantage of a combo over a cmdbtn is that, you can actually have
various options such as "Bad Number", "Temporarily Disconnected","Inactive"
etc which you can query based on the status. Cmdbtn does update, but with
only one value.
Signature

Sreedhar

> I have a DBS that has records in it that employees call.    I have created a
> form in which they input the data from the call.  Some records have multiple
[quoted text clipped - 6 lines]
> the easiest way (if there is one) to create this and do it?  Would I have to
> I have to make a subform for this?
 
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.