List Boxes
Have a table with the doctors names in column 1, then the other details in
column 2, 3, etc.
Then when you click on the listbox, take the selected value, do a VLOOKUP
into the table to extract the other details, and load the labels and
textboxes with that data.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"RC" wrote in message
...
I am creating a report with a listbox. The listbox contains doctors names
and when you click on a doctors names i want the label boxes and textboxes
on the page that give more inforamtion about the selected person to
change.
Can anyone tell me how to do this or give me a good website about
listboxes
and also comboboxes.
Thanks
|