I have a form that I created that I want the info to pull from the table tblCompanyInfo as a letterhead for every form and report.

I am trying to use the form_load command to pull the data the user puts in the Our Company Info form that gets saved to the table tblCompanyInfo. Then when they click on the switchboard button titled New Order. The form comes up automatically with their company info at the top of the form in the header section.

I have tried several ways to achieve this and have been unsuccessful. All I can say is Damn us Newbies! :-)

Any help in getting this to work will be appreciated.

Thanks.