I tried without success to find an answer to this question in Access Help and in Woody's "Special Edition Using Microsoft Office 2000." I think I just don't know what to call the thing I'm trying to do. (I'm not a developer--just a part-time employee trying to create and improve a database, and I'm learning Access on the fly.)
I have a report that displays a student's name, SSN, and Employee ID in the report header. When we launch the report, a "parameter" box pops up to prompt the user to enter the student's Employee ID. We enter those four digits, and the report opens with all that information in the appropriate places. There is one more field (Next assessment date) that doesn't get populated because the data source rarely has that information available. The data source is a linked Excel spreadsheet (table). The linked table has a field for this item, but the fields are either empty or contain inaccurate or out-of-date information.
However, the student's (employee's) next assessment date is fairly easy to calculate in one's head using information readily available from other sources. So the boss has asked me to add another prompt for the assessment date. The process would work like this: The user launches the report and gets the prompt for the employee ID number; the user enters the four-digit number (same as now) and presses Enter. Next the user sees a prompt for the student's next assessment date. The user keys in the information, and the report appears on-screen with all the text boxes nicely filled in.
By the way, it would be nice if the procedure adds this information to the data source! <img src=/S/grin.gif border=0 alt=grin width=15 height=15> Also, if the field in the data source is empty AND the user cannot determine the date (not unusual), we'd want the field on the report to remain blank. (So we can fill it in with pen-and-ink on the paper copy later.) How can this be done?