Printing current form record

[didacticone]

i have a form that lists job orders for a given day that i enter myself, and then i have a print button with the following code

If IsNull(Me!ID) Then
MsgBox "Please select a valid record", _
vbOKOnly, "Error"
Exit Sub
End If
DoCmd.OpenReport "WORK ORDER REPORT", , , _
"ID = " & Me!ID

i have made a report that will print the current record based on the "ID" field. this sort of works except for the fact that when i type in my jobs, and click the print button it just prints a blank report, but if i close the form and then reopen it and go to the record i want and click print, it works fine... is there any way to remedy this and just click print, instead of having to reopen the form... thanks

[NeoPa]

Perhaps you could redo your last paragraph. Imagine the person reading it needs to understand exactly what you did when and what happened in those circumstances.

[didacticone]

ok sorry about that, essentially if i fill in my form and click the print button, my report prints out but its blank. if i close the form and reopen it, then click print, the data prints. it seems as though the data is not recognized by my report until i close and reopen the form. does that help?

[patjones]

Hi,

It sounds like you have a list box or some other means of displaying a list of jobs on the form, and that when you select one of the records and hit your print button, you want the report for that record to print. Is this correct?

Pat

[NeoPa]

Let me take a stab at what you're trying to say. I've tried to read between the lines here but there's still very little reliable information to work off so let me know if I've got it wrong) :
You have a report that should be opened (for display only as far as the code goes), but when running the code above (Post #1), instead of showing the matching record in the report, it shows an empty report.

The form has a control (possibly TextBox but ?) called [ID] which is used to filter the report. The [ID] value is numeric and is stored in a table that the form is bound to. This may be the same table the report is built on (bound to) but it may not. Whenever the {Print} Command Button is clicked, the [ID] from current record is the one that is used to filter the report.

If you can confirm this is what your question should have said then I can tell you that your code ought to be working and something strange is going on here. If, on the other hand, my assumptions about your question are wrong in any detail then you need to point that out.

If there is something strange going on, that is no cause for serious alarm. We can often manage to resolve quite complicated issues here, as long as we have a clear understanding of what those issues are.