Hello all,

i currently have been trying to use a combobox, that when
a value is selected from the list, or a new piece of data
is typed in, it will look though column "AX" to find that
value, then display the coresponding data from "AY" in
different textboxes.

if anyone would like more info please just ask,

but help on using a decent command line would help cause
afterupdate is awful as you do not click off the obect
when you select a value!!!

thank you,

Robert Couchman

Robert,

I would have said just use ListIndex and offset from that, but this line
confused me

but help on using a decent command line would help cause
afterupdate is awful as you do not click off the obect
when you select a value!!!

could you elaborate?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Robert Couchman" wrote in message
...
Hello all,

i currently have been trying to use a combobox, that when
a value is selected from the list, or a new piece of data
is typed in, it will look though column "AX" to find that
value, then display the coresponding data from "AY" in
different textboxes.

if anyone would like more info please just ask,

but help on using a decent command line would help cause
afterupdate is awful as you do not click off the obect
when you select a value!!!

thank you,

Robert Couchman

if you could help me do that it would be great cause i
have more than one record with that date, i actually have
12 records with the same date, but the same time (what im
trying to put in a single textbox) is used for 2 records
in the list. so i have 6 textboxes to update.

if i use the command combobox1_afterupdate()
it will not update anything untill the next object is
selected e.g. you would need to tab to next object, or
click on a different part of the form.

any help bob??

thank you,

Robert Couchman

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

wrote in message
...

if you could help me do that it would be great cause i
have more than one record with that date, i actually have
12 records with the same date, but the same time (what im
trying to put in a single textbox) is used for 2 records
in the list. so i have 6 textboxes to update.

if i use the command combobox1_afterupdate()
it will not update anything untill the next object is
selected e.g. you would need to tab to next object, or
click on a different part of the form.

any help bob??

thank you,

Robert Couchman

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

You're the one looking for help.

I was looking for clarification on where the time would be found to restrict
the possibilities to two records.

Your explanation went into combobox this and textbox that, concatenating
cells with the plus sign and changing a textbox with code and triggering
subsequent code in afterupdate - no it doesn't help me. I have no idea what
you are trying to do or what help you need.

--
Regards,
Tom Ogilvy

"Robert Couchman" wrote in message
...
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