Fieldname with space and OnClick procedure

  • Thread starter Thread starter Betsy
  • Start date Start date
B

Betsy

I get an error using my field "Print Date" for a
str...this is what I have:

Dim strField As String 'Name of date field.
Dim strWhere As String 'Where condition
strField = "Print Date"

strWhere = strField & " < " & Format(Me.txtEndDate)

The statement ends up like: "Print Date < 11/01/03" and
gives me a syntax error.

I tried Print_Date and it doesn't see the field. How do I
code a fieldname with a space?

Thanks in advance!
 
Back
Top