Combo box to Report

[Jessica240]

I have a combo box on a form that allows the user to select a check date from a table that has our company's payroll schedule. The payroll schedule table has 3 fields: 1 for the check date, 1 for the beginning pay period date, and 1 for the ending pay period date.

When the user selects the check date, I want that check date with the beginning and ending pay period date to show up in a text box on my report.

The text box on my report has the combo box listed as the control source, but this results in only the check date showing up on the report.



How do I get the beginning and ending pay period dates to accompany the check date displayed on the report? Should I create 2 more text boxes?



Thanks,

Jessica

[amrut]

Do not know your data structure, but to display two more dates you need two text boxes.