Hi,
I hope someone can help me solve this problem with my database. I have tried many approaches without success.
I have a database with a main form called “frmMainDB” and on this form is a tabbed control called “TabControl1” with four tabs associated with this control. The problem is on the first tab called “BMFA Achievements”, which has a sub form associated with this tab which is set to display details in “Datasheet” view. The page name for this tab is “BMFAAchievementsSubForm” and the page number for this control is “0”. The sub form name for this tab is “BMFAAchievementSubForm” the link master property is set to the primary key “MainDBID” (auto numbered) on the main form table “tblMainDB”, the link child property is set to a numbered key “BMFAAchievementDBID” on the sub form table “tblBMFAAchievementsSubForm”. The BMFA Achievements sub form datasheet has four columns with headers from left to right as follows; “BMFA Achievement”, “Date Achieved”, “Examiner” and “Comments”. The datasheet can have as many as twenty rows for each member and when the focus is set to any of the locations under the header “Examiner” this triggers an event to load a form called “frmExaminerSelection”, this form is populated with the following controls; a Multi-Select Listbox and a form close button. When the selection from the multi-select listbox has been made the “Close” button is selected and the selection in the listbox is added to a string called “strList” where the data is stored as a “comer delimited concatenated text string”. It is this data stored in the string that I require loading into the location that has (had) focus under the header “Examiner”. This would need to be completed on the “Close Button” event on the “frmExaminerSelection” before the form closes. Would this be possible?
The full database is available for testing if it is required as this is a test database and carries no valid personal member details therefore does not contravene the Data Protection and Privacy regulations.
Regards,
SydC.
I hope someone can help me solve this problem with my database. I have tried many approaches without success.
I have a database with a main form called “frmMainDB” and on this form is a tabbed control called “TabControl1” with four tabs associated with this control. The problem is on the first tab called “BMFA Achievements”, which has a sub form associated with this tab which is set to display details in “Datasheet” view. The page name for this tab is “BMFAAchievementsSubForm” and the page number for this control is “0”. The sub form name for this tab is “BMFAAchievementSubForm” the link master property is set to the primary key “MainDBID” (auto numbered) on the main form table “tblMainDB”, the link child property is set to a numbered key “BMFAAchievementDBID” on the sub form table “tblBMFAAchievementsSubForm”. The BMFA Achievements sub form datasheet has four columns with headers from left to right as follows; “BMFA Achievement”, “Date Achieved”, “Examiner” and “Comments”. The datasheet can have as many as twenty rows for each member and when the focus is set to any of the locations under the header “Examiner” this triggers an event to load a form called “frmExaminerSelection”, this form is populated with the following controls; a Multi-Select Listbox and a form close button. When the selection from the multi-select listbox has been made the “Close” button is selected and the selection in the listbox is added to a string called “strList” where the data is stored as a “comer delimited concatenated text string”. It is this data stored in the string that I require loading into the location that has (had) focus under the header “Examiner”. This would need to be completed on the “Close Button” event on the “frmExaminerSelection” before the form closes. Would this be possible?
The full database is available for testing if it is required as this is a test database and carries no valid personal member details therefore does not contravene the Data Protection and Privacy regulations.
Regards,
SydC.