Confirmation Report

[Hysteria86]

I've a form that adds records to a table.

What I'm aiming to do is return a report with the information that was just entered (this is a booking system so this would be a confirmation report), but have no idea how to go about it.

Even a button on the form that produces this report, or just go to the record in the table as a means of confirmation, if that is any easier?

 

[Rickster57]

report

In the query criteria that your report uses as it's recordsource set the roomid, dateid,timeid (or whatever you call the three fields) to roomid:forms![myentryform].[roomid] and then the same pattern for dateid and timeid. Behind the onclick event of you command button on your myentryform use the docmd.openreport function

Query example:

roomid dateid
criteria forms![myentryform].[roomid] forms![myentryform].[dateid]

The criteria must match the names of the text boxes on your form

 

[Hysteria86]

Thanks, the report opens, only problem is there is no information on the report (the fields are blank). Presume this is something to do with the query? I've set it up as you suggested so I'm not sure where it is going wrong.

I'm using a button with the function 'Add Record', so I can't use a function that prints the information currently on the form, as an AutoNumber (BookingID) has not been issued yet. The record is added, and assigned an Autonumber, and it is this set of information I'm looking to return.