I have managed to get the 'OpenSaveFile' to work in my db but I have major problems getting it to work as a Subform.
I have the MainForm called 'frmMainMenu' in which I have a subform called 'frmHistory'. Those two forms are linked via the 'CompID' which is in text format and the 'HistID' which is also in text format.
Within the 'frmHistory' I have created another subform with the 'OpenSaveFile'. They are linked via 'Hkey' which is an Autonumber and the 'FileID' which is in Number format.
This is how it should work:
1. One company creates multiple history data. - this works fine -
2. To every history data you attach multiple files via 'OpenSaveFile'.
- This is the part that doesn't work. What happens is that the files attached stay the same for all other History records. Meaning, if I attach a file for History record '01' it stays the same for '02' etc.......
I do not seem to be able to link the relevant files to the specific History Data.