Printing current record on a form with subform

[vincentsp]

Hi All,

I'm using a form with subform for my colleagues/employees to fill in their daily time sheets.


The form displays employee names and the subform which is a multi entry form gives me the activities carried out that day together with the corresponding times.

At this moment I'm using a query which asks me what time sheet to print by name and date.
But I'm trying to find a way to print the current record / time sheet in my form directly.
I found several topics handling this issue on this forum, but none of them working due to my multi entry subform.

[June7]

What do you mean by 'multi-entry' - continuous or datasheet view?

Should print a report, not the form.

[vincentsp]

Sorry for the confusion I meant continuous form.
And I am trying to print a report. But only of the visable/active records on the form.

At this moment I'm using a query which asks me what record to print based on date and employee.
But I want to skip this step by being able to print the record thats visable/active on the (timesheet) form.

[June7]

The selected record will be in the subform?

Use the WHERE CONDITION argument of OpenReport. The syntax will depend on where the code is placed. If button on main form:

DoCmd.OpenReport "report name", , , "ID=" & Me.subformcontainername!ID

[vincentsp]

Hi June7, sorry for the late reply but it took me a while to figure it out and get it working .
But thanks again for your help!