Hello,
I am trying to have some DLookUp functions updated automatically.
I have one table where I enter the monthly average exchange rate of currencies, the entry is made in the beginning of the following month.
I have one table, where I enter all invoices and date of invoice. At the time when I enter the date, the monthly rate is not yet available.
I have this code that is working ok, as long I have the Xrate already in the table:
Private Sub InvDate_AfterUpdate()
Me.[XrateAtInvoiceDate] = DLookup("[XrateInvDate]", "XrateQueryInvDate", "InvoiceID =" & Nz([InvoiceID], 0))
End Sub
How to have the values updated when I enter the exchange rate ?
Thank you for helping,
Philippe
I am trying to have some DLookUp functions updated automatically.
I have one table where I enter the monthly average exchange rate of currencies, the entry is made in the beginning of the following month.
I have one table, where I enter all invoices and date of invoice. At the time when I enter the date, the monthly rate is not yet available.
I have this code that is working ok, as long I have the Xrate already in the table:
Private Sub InvDate_AfterUpdate()
Me.[XrateAtInvoiceDate] = DLookup("[XrateInvDate]", "XrateQueryInvDate", "InvoiceID =" & Nz([InvoiceID], 0))
End Sub
How to have the values updated when I enter the exchange rate ?
Thank you for helping,
Philippe