Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

HOW TO GET USER COMMENTS FROM FORM TO TABLE TO REPORT???

Status
Not open for further replies.

AccessNovice

Programmer
Feb 7, 2001
24
US
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
 
I would suggest creating a subreport to display these comments. You could add it to the report footer. All you need is a way to insure that only records pertinent to that report are displayed. If the table is specific to the report then this is no problem. If there is a field in the table that defines which report it belongs to you may need to modify the main report's query to include a field to link the subreport to that let's it know which report is being printed.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top