Results 1 to 1 of 1
  1. #1
    Join Date
    Nov 2002
    Posts
    15

    Red face Unanswered: OpenSaveFile as Subform

    Hi There,

    I am struggling quite badly with my DB.

    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.

    Has anybody got any thoughts?

    Thx in advance

    Alex
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •