AccessNovice
Programmer
Here is my situation. A user of access 95 wants to add comments(after viewing a report) to one of the 13 access reports. When the start the database they will first see a switchboard with an informative label telling them...
..."if you wish to add comments to a report, first use the command buttons on this switchboard to take you to the report of your choice. After viewing report, close it, return to this form, add comments in proper textbox and click cmd button to its right."......The user gets to that certain report-views it, can't add comments directly!-and closes it before returning to main form-here user adds comment to 1 of 13 textboxes on main form and clicks 1 of 13 command buttons-main form has cmd buttons to get to the 13 reports, it also for inputing comments-has 13 textboxes and 13 enterinfo cmd buttons....From here I want the information to populate 1 of 7 tables(each table has a field called Note which holds old and new user comments like "low pressure...".)
How to get all comments from that certain table(old and that recent one) to populate a textbox on the report-with a 'format/output/filtering' of information like 1: low pressure 2: another comment 3: most recent comment just typed in
..."if you wish to add comments to a report, first use the command buttons on this switchboard to take you to the report of your choice. After viewing report, close it, return to this form, add comments in proper textbox and click cmd button to its right."......The user gets to that certain report-views it, can't add comments directly!-and closes it before returning to main form-here user adds comment to 1 of 13 textboxes on main form and clicks 1 of 13 command buttons-main form has cmd buttons to get to the 13 reports, it also for inputing comments-has 13 textboxes and 13 enterinfo cmd buttons....From here I want the information to populate 1 of 7 tables(each table has a field called Note which holds old and new user comments like "low pressure...".)
How to get all comments from that certain table(old and that recent one) to populate a textbox on the report-with a 'format/output/filtering' of information like 1: low pressure 2: another comment 3: most recent comment just typed in