Report opens differently from form (Access 2000)

Topic

New Reply

Subject edited by HansV – “Solar” (your user name) is not a very descriptive subject for a post about Access

Why is it so that when i open the report by itself it opens with all the records, while when i open it through the form, it shows only the first record?

Reply | Quote

Replies

Look at the On Click event procedure of the command button Command15. It filters the report to display only the orderid from the current record in the form:

stLinkCriteria = “orderid = ” & Me![orderid]
DoCmd.OpenReport stDocName, acViewPreview, , stLinkCriteria

Reply | Quote