For this sort of problem, I use a Tally table to generate blank rows in the Record Source rather than rely on code. Your Tally table needs an integer column with rows containing values from 1 to the max number of labels on a page. Then your Record Source looks like:
SELECT " " As PersonName, " " As PersonAddress, " " As PersonCity, …
WHERE TallyTable.Counter <= [Forms]![SomeForm]![RowsToSkip]
SELEC PersonName, PersonAddress, PersonCity, …
Open your dialog (it must open WindowMode:=acdialog) from the report Open event - Open occurs BEFORE the record source gets loaded. The user picks the number of rows to skip (can be zero), then clicks a button that runs code to hide the form to let the Open event continue. In the Close event of the report, close the hidden form.
John Viescas, Author
SQL Queries for Mere Mortals
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
On Jun 23, 2016, at 2:10 PM, firstname.lastname@example.org [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Posted by: John Viescas <email@example.com>
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (2)|
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.