printing out multiple selection values

[reyrey]

i have a split form (access 2007) that takes in new information on top and has related historical data on the datasheet part on bottom. i would like to print a report based on the new information added - just one sheet with one record - that will be used to write notes on by a maintenance crew. there is a combobox that allows for multiple selections on the form. i added a button for printing. when i print the report, it prints the associated number(s) of the checkbox associated with the multiple value selection(s) and not the text value(s) i need. how do i remedy this? modify the default query? thanks.

 

[vbaInet]

Is there an ID field that automatically increments which you can use to identify the latest record? Or a Date/Time stamp perhaps? If you have one of those then:

1. Set up your report to return all records.
2. Use the DMax() function to find the ID or Date that corresponds to the latest record. See here for more on DMax:
http://www.techonthenet.com/access/functions/domain/dmax.php
3. When opening the report, filter the records using the WHERE part of the OpenReport command. See here for examples (substituting OpenForm for OpenReport):
http://baldyweb.com/wherecondition.htm