![]() "SELECT Contacts.ID, Contacts.first_name, Contacts.last_name, Contacts.email, " _ Private Sub Report_Open(Cancel As Integer) ![]() The following is a sample of the completed event that sets the RecordSource property to pull from a SQL statement. This will put you into the VBA environment and create a new blank subroutine for the Report_Open event. If you’re not experienced with VBA, then, in the reports design properties panel, find “On Open” under events and use the ellipsis (…) button to select the Code Builder. This will automatically assign the query, table or SQL to the property and populate the report when it opens. In this case, the Record Source property can be set using VBA code through the On Open event when the report is first opened.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |