PhotoFrang
Programmer
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.
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.