I have finally managed to get the 'OpenSaveFile' to work in my db but I have major problems getting it to work as a Subform (and I am not even sure if it needs to be a Subform).
I have the MainForm called 'frmMainMenu' in which I have a Subform called 'frmHistory'. Those two forms are linked via '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 FILES ATTACHED FOR ONE HISTORY RECORD (EG: HISTORY RECORD '01') STAY THE SAME FOR ALL THE FOLLOWING RECORDS (EG: HISTORY RECORD '02' ETC.......)
I DO NOT SEEM TO BE ABLE TO LINK THE RELEVANT FILES TO THE SPECIFIC HISTORY DATA. -
I have attached a screenshot which should clarify the setup.