Put contenst of field off table on repor tbased on date

[BorisGomel]

Hello everybody,
I have failry large table called QBInvoices that consist two fileds- qbinv and date . Also, I have a report that showing infos off qvery called TotalQueryQB. The table and query have no realtions except dates . I need to show on report filed qbinv off table QBInvocies on the top of the reprot based on date. The user type date on form -frmQB text box txt Date and I would like to have contest of field qbinv off table QBInvocies on the top of the report base on date that was typed.
Thank you in advance for help,
The bst regards,
BorisGomel

[June7]

You want to filter report RecordSource based on date entered by user on form?

One way is to use the WHERE CONDITION argument of DoCmd.OpenReport:

DoCmd.OpenReport "report name", , , "datefield=#" & Me.textboxname & "#"

[BorisGomel]

You want to filter report RecordSource based on date entered by user on form?

One way is to use the WHERE CONDITION argument of DoCmd.OpenReport:

DoCmd.OpenReport "report name", , , "datefield=#" & Me.textboxname & "#"

tHNAK YOU JUNE 7.THAT WORKS!!!