Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sending a Fax

Status
Not open for further replies.

PhotoFrang

Programmer
Jun 10, 2003
5
CY
Friends,
I have two tables, with their forms. The one is Orders, which has the fields: [Order ID], [Suppliers Company], [Product], [Quantity of product], [Price per Unit], [Total Price] and [Order Date].
I also have the Suppliers Form which has the fields:
[Suppliers ID], [Company Name], [Address], [City], [Postal Code], [Country], [Phone], and [Fax No].
What I want is to create a new form, from were I am going to send a fax to the Supplier Company for the Order. So I want to click on the Send Fax button in the Orders form, and go to the new form, and use the [Suppliers Company] field in the Orders form, to find the data in the Suppliers form needed, which is the [Fax No], and write it in the [Fax No] field in the new form. It should also get from the orders form, the [order date], which is going to be the [Send Fax Date] in the new form. Finally I would like to know if I you can tell a good code, to send the fax.
I am using MS Access 2002.

Thank you very much for your time, and I hope you will be able to help me.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top