Button to Generate Report from Form

[faythe1215]

I'm fairly new to this, so please, bear with me. I'm currently working on a large project. Part of what I'm using stores recipes. I have three tables, one that stores recipes, another that stores items, and the last one joins the recipes with specific items.



I have managed to create a Report that enables me to view them continuously, and a Form that does as well (for easy entering), but I am having trouble figuring out how to have a recipe displayed in Form view and (with a button) view the recipe in the Report (in record view - so only the one recipe is showing).

[pbaldy]

Is this appropriate?

http://www.baldyweb.com/wherecondition.htm

[faythe1215]

I suppose that could work, I was hoping to open it in report view (if it's possible).

So, I suppose the first question that really needs to be answered is if it's possible to view one record at a time in report view as it is in form view.

Like this - but I really only want one recipe to be viewed at a time in report view.
Attachment 19548

[June7]

Can open report filtered to single record using the code method from Paul's article. Or can configure report to show each recipe record on a separate page in print preview.

Can open in report view or print preview. This is possible with argument of OpenReport. Should get familiar with the arguments of OpenForm and OpenReport methods. https://msdn.microsoft.com/en-us/lib...ffice.15).aspx

[faythe1215]

You're right, June7, I don't know how I missed that!

I'm having a bit of trouble with the SQL syntax. As I understand it, when I click on the item, in the instance below, a text field, it should open my report filtering on the specified record. But what happens is a dialogue box pops up asking for me to enter 'txtRecipeName'. If what I type matches something, ALL my recipes are displayed. If it doesn't match anything, then a blank record is displayed (both in report view, though).

Also, please see the attached database. Thanks for all your help! I really appreciate it.

Private Sub txtRecipeName_Click()
    Dim Name As String
    Name = Me.txtRecipeName
    DoCmd.OpenReport "rptRecipeList", acViewReport, , "txtRecipeName = '" & Name & "'"
End Sub

Attachment 19555

[pbaldy]

txtRecipeName needs to be the name of a field in the report's source. Name needs to be the name of the textbox on the form.

[faythe1215]

Yes, that is the case.

[June7]

So did you fix the code? Is issue resolved?

[faythe1215]

I already have it written the way he had specified. txtRecipeName (is the field on the Report) Name (is retrieved from the Form).

[June7]

Name is a reserved word and should not be used as name for anything. Use something like: tbxName. Then in VBA code: Me.tbxName

[faythe1215]

I have changed the variable name and am still encountering the same issue.

[June7]

Variable name? I thought you were referencing a textbox control on form? The suggestions indicate to reference control name.

If you want to provide db for analysis, follow instructions at bottom of my post.

[faythe1215]

Revised:Attachment 19559

[June7]

Okay, here is what I see.

The field name is RecipeName.

The textbox name is txtRecipeName.

Therefore, the correct code is:
DoCmd.OpenReport "rptRecipeList", acViewReport, , "RecipeName = '" & Me.txtRecipeName & "'"

However, you have code behind rptRecipeBook. This won't work if the report is opened in Preview mode. Why isn't code behind form?

[faythe1215]

I was actually just playing with it to get it to work! lol I knew it had to be something silly and simple like that. D'oh!

Thank you both for your help and your patience. This is a big project for me to take on, so there might be more questions. Thanks again!