I've attached the correct Access 2016 database with an example of the form I'm trying to create.
My goal: a form allowing the user to choose one or more currencies from a listbox and update their exchange rates for several years.
The background tables are as per this relation diagram:
So I have a mainform, where I can choose the currencies (plus a Type of foreign exchange conversion, which defaults to Standard).
Then a subform in datasheet form, which is meant to filter for the Currencies selected, showing the rates for all the years.
The user would then overwrite the rates in that subform as required. Here is a picture of a 'mocked-example':
The subform control has Master and Child Field Links to link the mainform listbox to the subform record source, as shown in this pic:
But the Currency link is not working.
However, the link to the mainform combobox for Type seems to be working.
So I've even tried a bit of VBA to get it working...no joy there either.
I'd like the subform to show rates for the years 2014 to 2017.
Thus the subform should show 4 rows for each currency selected.
At the moment, only the 1 row appears, and while it updates for the Type selected, it refuses to show the Currency selected.
Any advice on how to correct my form to achieve this?
Many thanks in advance,
PS, a cross-tab layout would be idea, with the selected currencies as column headers.
However, I've avoided this because it seemed a bit complex to get around the non-updateable nature of a cross-tab query.