Macro condition -> Data Type Mismatch -> Help!

[johndoh!!]

I have a report based upon a query of two tables. I am trying to have "Discontinued" be displayed in a Unbound text box next to any discontinued items. One table has a Yes/No field (formated as True/False) that is checked when the item is discontinued. My macro condition is: [Reports]![Report_Name]![Disc]=True. Am i missing something here?

I have tried to use other fields in the form just to test and it ALWAYS gives me a Data Type Mismatch, no matter what i do!(when using a text field for example i use ="" to see if the macro will give the error... it does!)

Any help would be GREATLY appreciated!!

Thank you for your time.
Doh!!

 

[Surjer]

Does this help Any?

Private Sub Command3_Click()


Me.RecordSource = "Select * from [Youre Table] where [Youre Table].[truefalse] = true"

Text1.SetFocus ' Unbound Text Box
Text1.Text = "Discontinued" ' Sets it To Discontinued

End Sub

 

[Pat Hartman]

In the Current event of the form put:

If Me.Disc = True Then
Me.YourUnboundField = "Discontinued"
Else
Me.YourUnboundField = ""
End If

Then in the AfterUpdate event of the checkbox put:
Call Form_Current