As I believe I answered in another forum, you can display all four phone
numbers from a table of company phone numbers using 4 copies of the same
subform. These can be linked use the primary key from the main form as well
as 4 different text boxes that correspond to the phone type.
--
Duane Hookom
Microsoft Access MVP
Allen Browne said:
Try a text box with Control Source of
=CurrentDb.Name
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Reply to group, rather than allenbrowne at mvps dot org.
dwinn68 said:
How do I add the file path to the footer in a report. Similar to Excel's
file
path ( &[Tab]&[Path]&[File] )