Hello,

I need help with carrying information in one field on an invoice to the same field on the next invoice. Their are multiple contractors in my DB, each contractor may have one or many invoices. Each contractor had the option to pay in EURO, GBP or USD. This is how it is set up on the contractor informaion screen I choose the currency information by choosing a checkbox(EURO or GBP and USD is the default). This information is then displayed on the invoice. Now this is my problem the currency inforamtion shows up on the 1st invoice but if the contractor has several invoices the selected currency does not show. I've tried several things to make this work with no success.

This the current code I have.
Currently I'm storing the currency information in the contract tables.

'If EURO is chcked display EURO on invoice form
If Forms![Invoice Scanner].EURO = True Then
   Forms![Invoice Scanner]!InvSub.Form!CurPayIn = "EURO"

'If GBP is checked othen display GBP on nnvoice
ElseIf Forms![Invoice Scanner].GBP = True Then
       Forms![Invoice Scanner]!InvSub.Form!CurPayIn = "GBP"

'If GBP and EURO = false then display U.S. dollars
Else
Forms![Invoice Scanner]!InvSub.Form!CurPayIn = "U.S."

End If


Please Help!!!!!!!!!!!!