Access to a custom form that inadvertently modifies data table entries

I use MS Access to create pdf reports based on a table. I created a form containing a text box for entering the client name (this value is in the main table) and a button that, when clicked, launches the code:

Private Sub cmdPrintRecord_Click()

    Dim strReportName As String
    Dim strCriteria As String

    strReportName = "Current SP Report"
    strCriteria = "[Owner]='" & Me![Owner] & "'"
    DoCmd.OpenReport strReportName, acViewPreview, , strCriteria

End Sub

The idea here is to create a separate PDF report based on the customer name.

The above procedure was able to do this successfully, however, I came across this, since when it starts, the data in my table changes, in particular the client name field.

: "", 10 , , , 11 . , .

- ?

.

MS, : https://support.microsoft.com/en-us/kb/209560

+4

Source: https://habr.com/ru/post/1653939/


All Articles