how can i use a list box and command buttons

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top