open report command - wherecondition

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am writing an docmt.openreport where a condition exists. How do I request
user imput on the condition?
 
Place a control on your form that contains your DoCmd.OpenReport method and
try something like:

Dim strWhere as String
strWhere = "1 = 1 "
If Not IsNull(Me.txtStartDate) Then
strWhere = strWhere & " And [DateField]>=#" & Me.txtStartDate & "#"
End If
DoCmd.OpenReport "rptYourReport", acPreview, , strWhere
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OpnReport with multiple conditions 2
WHERECondition in a report. 1
Reporting total number of clients 2
Help needed 0
access open report where condition 1
Access Open Form with WhereCondition 6
Can I view a reports Recordset 6
Report using union query 2

Back
Top