I have a little problem I need help with. I have two subforms one is called "Estimate" the other one is called "Internal/Invoice". In the estimate subform there is a button called "Export to invoice" when that is clicked the approriate information from Estimate (using SQL statement) is then transfered to the invoice subform. In the invoice form there are information about the invoice and a field called "Invoice Number" that field is disabled, unless specified by user. An invoice number is entered in there and must be entered in order for the information to work and link with the parent client table.
I want from the Estimate subform when I click "Export to invoice" I want to be able to enable "Invoice Number" in the invoice subform, enter a value in the "Invoice number" disable it, the value is automatically entered (using VB code which I know off that is not the problem) into the subform "Invoice", in the field "Invoice Number". But I also want to take first the Estimate Number from the Estimate sub form have that value stored into the Invoice Number in the invoice subform and incriment the estimate number by one, then allow the transfer from the Estimate to the Invoice.
Can anyone help me do that part? I know how to use VB coding I just to do know how to do what I described above. Any help would be greatly appreciate it. Thanks in advance.
I want from the Estimate subform when I click "Export to invoice" I want to be able to enable "Invoice Number" in the invoice subform, enter a value in the "Invoice number" disable it, the value is automatically entered (using VB code which I know off that is not the problem) into the subform "Invoice", in the field "Invoice Number". But I also want to take first the Estimate Number from the Estimate sub form have that value stored into the Invoice Number in the invoice subform and incriment the estimate number by one, then allow the transfer from the Estimate to the Invoice.
Can anyone help me do that part? I know how to use VB coding I just to do know how to do what I described above. Any help would be greatly appreciate it. Thanks in advance.
