DoCmd.OpenReport Problem

[lowesthertz]

I am having a problem getting the do.cmd.openreport to work for me. I have a form, which I have a botton on. The on_click for the button has the follow. All I am trying to do is when I have the form open, click the button to open the report with the current record in the preview screen.

Private Sub Command382_Click()
DoCmd.OpenReport "CAREmail", acViewPreview, , "LabNum = " & Me.LabNum
End Sub

So if I have the form open, with a record showing...When I click the button, the report opens but is blank (no record).

I have a report called "CAREmail" which is basically a copy of the form. If I open the report independantly, it seems to work fine. One of my questions that might be part of the problem, the key in the table is called "LabNum", the box on the form that shows the key is "ID". Which should I be showing in the DoCmd? Any other ideas what I am doing wrong?

Thanks
Chris

[JeffChr]

try using Me!LabNum instead of Me.LabNum for the filter

[lowesthertz]

I get the same blank form with the "!" instead of the "."

[orange]

One of my questions that might be part of the problem, the key in the table is called "LabNum", the box on the form that shows the key is "ID".

You could try the following, but I'm not clear on the name of the control vs the name of the field in the table.
DoCmd.OpenReport "CAREmail", acViewPreview, , "LabNum = " & Me.ID

If you go to the report design view, under the data tab, perhaps you could copy and paste the
Report's record source .

You could post a copy of the database.

[lowesthertz]

Sorry if I was confusing;
The primary key of the master table is "LabNum".
In my form, the text box is named "ID"

I tried the change in the doCmd and got the same result.

When I open the report in design view, the data tab shows the control source as my "Main Data Table" that stores all the records. No filters applied on that tab.

[evander]

Possible Causes:


1. The LabNum primary key is probably a text field. In this case, you should revise your argument to include single quotes.

2. The form and report do not have the same underlying query or table data source. The report might be based on a query that uses INNER JOINS. You should check if the underlying query itself displays data. If this is the case, try to eliminate the joins first, then re-introduce your joins to see what rows are eliminated when you join two or more tables.

3. The form is dirty, that is, the changes haven't been committed to the database yet.

[orange]

Please post some screen captures of you table design as well as your form's controls.
I think there is confusion regarding the names of each and the data types of each.
Primary key is not the issue here -- at least not the major issue.

[lowesthertz]

evander,

1) you are correct, the key is text and an example would be "15-001". Is this what you meant with the single quotes? As written, I get the same result.

Private Sub Command382_Click()
DoCmd.OpenReport "CAREmail", acViewPreview, , "'LabNum' = " & Me.LabNum
End Sub

2) When I run the report by just double clicking on the report in the left had pane, it opens and shows records just fine. Because there are no filters, it shows all records. I just tried putting my own query in between the report and the table and I still came up with the same result. Let me ask a question, I generated the report by copy and pasting the form onto the report. Could this be causing problems? Query design shown below, very basic.



3) it does not matter if I have made any change to the data on the form or not, I still get the same result.

[orange]

If LabNum is a text data type

try
Private Sub Command382_Click()
DoCmd.OpenReport "CAREmail", acViewPreview, , "LabNum = '" & Me.LabNum & "' "
End Sub

[lowesthertz]

orange,
Please see screenshots below. Is this what you were asking for?

[orange]

Did you try the change in post #9?

[lowesthertz]

If it is any clue at all, I also tried to generate a very basic report with only 5 or so fields from the report wizard, and I received the same result. No records showing the the report.

[lowesthertz]

orange, you the man! It worked! Thank you

[orange]

For your own learning/training you should watch some of the videos and do the tutorials shown here.

Good luck.