Making report show data from form and subform from print button

[ryanwales]

Hi guys/girls,

Before, I had a quote form that would only allow the addition of one product to each quote. the following VBA allowed fields from the form to appear in their corresponding fields in a report:

Private Sub cmdPrint_Click()
Dim strWhere As String

If Me.Dirty Then 'Save any edits.
Me.Dirty = False
End If

If Me.NewRecord Then 'Check there is a record to print
MsgBox "Select a record to print"
Else


strWhere = "[ID] = " & Me.[ID]
DoCmd.OpenReport "MyReport", acViewPreview, , strWhere
End If
End Sub

I attempted to use this on my newest form that allows multiple products to each quote and while the report appears with no errors, nothing shows up in the fields.
Can anybody shed any light on this?

Thanks in advance

[alansidman]

Change

strWhere = "[ID] = " & Me.[ID]

to

strWhere = "[ID] = Forms!YourFormName!ID"

[ryanwales]

Thanks for getting in touch so quickly. Unfortunately (even though once again there are no errors present) the same problem is happening, nothing appears in the fields!
What could be causing this?

Thank you

[alansidman]

Suggest you post your db to the forum and let us have a look at it.

Alan

[June7]

Alan, still need to concatenate the value from form control. However, changing code from the Me qualifier to the explicit form name should not make any difference. Something else is wrong. I suspect has to do with RecordSource. Better post database for analysis.

[alansidman]

Better post database for analysis.

I Agree with this. I pulled the Where statement from a report code I use and didn't have to use concatenation, but there is something fishy here.

[ryanwales]

Hi both, embarrassingly i believe it was a problem with the report query. I hadn't linked the query with the form as such and as a result it was showing results from the query (where there were none..hence it being blank -doh!). Sorry for wasting your time on that one.

I still have a problem showing multiple values however. When I click print report, the products come up in separate sections with recurring details such as quote ID, total price ect.

QuoteID, customer, subtotal, tax, shipping and Quotetotal only need to come up once, whereas the product name, qty, listprice and total would ideally be underneath eactother.

How do i go about it?

Thank you both

[June7]

Depends. If you are printing a single quote for one customer put the QuoteID, customer, subototal, tax, shipping and quotetotal items in header or footer sections.

[ryanwales]

Depends. If you are printing a single quote for one customer put the QuoteID, customer, subototal, tax, shipping and quotetotal items in header or footer sections.

Yes, it'll be a single quote per customer that could have more than one product on it.

Thanks, I'll try it now!