Fax Order Form Ideal

[lookup13]

Hello All,

This is what I have , I have a 4000 item database on products for different Customers.Where and how to buy them etc.(vendor name address Etc). In excel we created a fax form for each one of these items.(over time either excel or access data begins to differ on price or updates).
I would like to import our fax form and use it in access,you know something like a template. you enter a part Number and it fills in vendor etc.
Can this be done ?

 

[kweitzel]

Hi Lookup13,

I have never heard of using Excel Workbooks as templates for this, but why don't you design a report in Access as a fax template?

regards

Klaus