How can I input an entire address on a form or report , this list is
currently in excel?
I want it to enter like the example below when chosen from a drop down list.
AB fabricators
124 Main
Anywhere, Texas 43434
POC John Doe
Fax 999-999-9999
Phone 888-888-888
Answered in microsoft.public.access.
Please don't "multipost" the same question to multiple newsgroups. It wastes
the volunteers' time to answer a question in one group only to find that it's
been answered in another.
To solve your problem - create a Table in Access with the fields for this
data, and use File... Get External Data... Import to import from Excel into
the table (choose .xls from "Files Of Type"). Then create a Form (for onscreen
use) and/or a Report (for printing) with textboxes for the fields, laid out as
you see fit. For a Form put a combo box on the form using the toolbox Combo
Box wizard to let you select the company name and navigate to that company's
record. You can also open a Report based on a specific record - base it on a
Query referencing the form combo box.
John W. Vinson [MVP]
