Thread: Anyone can help
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Robert Couchman[_4_] Robert Couchman[_4_] is offline
external usenet poster
 
Posts: 64
Default Anyone can help

Hello Tom,

here is the stages i was considering for the event:=

== combobox_click() == search through rows to find where
the date is used == if date is found, check the date is
not used in another textbox == if not put into current
textbox == continue through records and input in next
available textbox.....

== textbox1_afterupdate() == look through records where
combobox1 (date) and textbox(i) (time) are in row, use
cells((i), 2) + " " + cells((i), 3) + " " + cells((i), 4)
in next available combobox (there are only 2 of these for
each time!!) == the datalist for the comboboxes will
contain all records where there is no date or time set for
applicant...

== combobox(i)_click() == datalist will contain all
records where no date or time has been selected == if the
person is moved off the list, then the persons record
should be updated so that no date or time is available in
there record THUS person returns on list for other
comboboxes....

hope this is some help!!

thank you,

Robert Couchman

-----Original Message-----
Use the click event for a combobox.


Where is the time specified - how does the code to know

what time to use to
select the two records that occur at that time?

--
Regards,
Tom Ogilvy