I have done a search on this forum and found all the postings relating to printing only the current record for a report. I
have a command button and have followed what these posts say. The report prints the current record but leaves out the data
from the subform.
The database is a recipe organizer. The main form is called Recipes and the subform contains the ingredients for each
recipe. This subform is called Ingredients.
I set up a command button with the following code:
Private Sub Print_Recipe_Click()
On Error GoTo Err_Print_Recipe_Click
Dim stDocName As String
stDocName = "Family Recipes"
DoCmd.OpenReport stDocName, acNormal, , "[RecipeID] = " & Forms!RECIPES![RecipeID]
Since the RecipeID is used in both forms and the report, I thought it would be the best field to use since it linked all the
So what do I need to do so that the subform data prints out on the report?