Date Searching Query

[randaj]

Why does this not work? I have a form the has two option/radio buttons, one Yes(optYes) and one No(optNo), in the same frame (fraDate). If No is selected I would like all values returned. If Yes is selected I would like to use the Between statement to input parameters. Here is what I have that is not working.

IIf([Forms]![frmAdvQry]![FraDate]![optNo]=2,[tblNotebook_Sub]![Date],Between [Start Date] And [End Date])

I set the data index value for No to 2, and Yes to 1.

 

[TomCologne]

Tell Access where [StartDate] and [EndDate] are: Between Forms!frmAdvqry![StartDate] And Forms.....

You're not alone,

TomCologne

 

[randaj]

That's not it. The problem is that it is always asking for the [Start] and [End] dates. It seems to me that it's not recognizing the value in the frame.

 

[TomCologne]

Try this:
[Forms]![frmAdvQry]!FraDate.optNo=2
I have not used frames yet, but your syntax would refer to 2 fields on the form.

Hope this helps,

TomCologne