Button Saves on a new Report 1

[AndreB]

How can I do this: I have 1 selection in a ComboBox and a something writen in a TextBox. I need to create a Button that after pressed saves the selection in the ComboBox and the TextBox in a Report and showing the exact time and date this Button was pressed....

 

[LonnieJohnson]

When you say "saves it to a report...", do you want the data stored in a table for future use or just printed? ljprodev@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

 

[AndreB]

I just want to print the data...

 

[LonnieJohnson]

I would take the following steps.


1. Add the fields to your report.
txtDate
txtComboInfo
txtTextInfo

2. In the report's On Open Event, I would reference the fields on the form.

txtDate = Now()
txtComboInfo = Forms![FormName]![ComboBoxName]
txtTextInfo = Forms![FormName]![TextBoxName]

3. Add a button that opens the Report in question in either preview or print mode.

'PREVIEW MODE
DoCmd.OpenReport "ReportName", acViewPreview

'PRINT MODE
DoCmd.OpenReport "ReportName", acViewNormal

Good luck ljprodev@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV