How to make efficient use of tools

  • Thread starter Thread starter Robert Couchman
  • Start date Start date
R

Robert Couchman

Hello, and good afternoon,

how, or what would you use to control the following:-

a number of comboboxes

in each combobox the a record can only appear once

a common list must be used for all the comboboxes

the list for the combobox must updatable

the data to be held in the list needs to display (name,
surname) but needs to be individual to the row(for lookup
reasons) so needs to include (but not be visible) the ID

if you pick a value off the combobox (name, surname) then
it will disaper off the list, and you can manipulate the
data related to that ID.

any help will do,

thank you,

Robert Couchman
([email protected])
 
Robert;

I have many examples on my website ( www.rosenkrantz.nl )
but I cannot get clear why you want to do all of this.
Maybe you can give us a brief hint of why you want to do this so it gives us
a better picture of the problem.

Mark.
 
the reason for this is part of a user form, that will
manipulate data to organise members of a apreadsheet.

these people will need to have time slots allocated, but
the same person cannot be put in more than one time slot,
and also the same timeslot cannot be used for many people.

therefore it is a form based 'Time table'

if you have any advice or guidence on this please get in
touch.

Thank you,

Robert Couchman
([email protected])
 
Back
Top