Using Unbound text boxes

[rbiggs]

I have a form with three unbound text boxes (txtDriverSelect, txtBefDate, txtEndDate) They filter the information on the form based on the user inputs. The problem I have is generating a report that reflects the same information. The report has a text box named DrverName. I have a onClick cmd on the Form to open the Report with the following in the where condition. But the report opens up blank. Does the txtboxes on the Report need to be unbound as well.



[Reports]![MileageReport]![DrverName]=[Forms]![DriverMileage]![txtDriverSelect]

Thanks

[ajetrumpet]

if you're gonna use a WHERE condition in an OPENREPORT action, it has to be syntax similar to this:

"[field] = '" & [Forms]![DriverMileage]![txtDriverSelect] & "'"

or for numerical values:

"[field] = " & [Forms]![DriverMileage]![txtDriverSelect]

Or you can throw them manually into the report after you open it. Note that the WHERE condition of OPENREPORT does not apply to unbound controls, because it's a filtering mechanism for the underlying source dataset.

[pbaldy]

In VBA code the syntax look like:

BaldyWeb wherecondition

I think in a macro you still only want the field name in the first part, but in truth I don't use macros. Whether the form textboxes are bound or not should not affect the operation of a wherecondition. On the report side, you're referring to a field in the underlying data, not a textbox on the report.

[rbiggs]

I put this in the Click event:

Private Sub Milage_RPT_Click()
DoCmd.OpenReport "Mileage Report", acViewReport, , "[Driver Name] = '" & Me.txtDriverSelect & "'"
End Sub

The other part of the form uses dates to narrow down the results. On the Mileage Report I have the field name corresponding to table where the dates are stored. How can I reference these in the where condition since they both have the same field name.

[pbaldy]

I'm not sure I understand. Are you saying the date field has the same name? Can you post the db here?