Report with a object

[joe31709]

I have copy and pasted a excel sheet into a report and I want to be able to pull in dates and have them populate areas of the sheet. My question is there will be 14 dates with information in each date. What would be the easiest way to do this. Should I make a footer or something like that with each item in it and when I click report it will put everything in there???


I am lost about this.

Any ideas.

Thank you,
Joe

 

[Fornatian]

Do the dates need to be in the worksheet itself or just displayed on the form? If just displayed on the form, you can easily reference an unbound text box to form field using:

=Forms![YourForm]![YourDateBox]

If it is that you need the dates in the excel sheet, you will have to delve in VBA, as the only way I know is to update the excel sheet before you open the report to make the changes direct. Do searches on this forum for Excel.Application and it should get you started.