Open Report From Subform on Main Form

[burrina]

I am missing something here, don't know what it is?

Main form is named CheckRegister and subform is named FReg


Report(s) are named ??? What's wrong with my syntax?


[BalDate] Between Forms!CheckRegister!FReg.Form!StartDate And Forms!CheckRegister!FReg.Form!EndDate And Void <3"

[ssanfu]

Are you doing this in code? what is the rest of the code?

You might try:

([BalDate] Between Forms!CheckRegister!FReg.Form!StartDate And Forms!CheckRegister!FReg.Form!EndDate) And (Void <3)

[burrina]

Here is the complete code and it is on the subform being called from a command button; CheckRegister is Main Form and FReg is subform.
DoCmd.OpenReport stDocName, acPreview, , "([BalDate] Between Forms!CheckRegister!FReg.Form!StartDate And Forms!CheckRegister!FReg.Form!EndDate) And (Void <3)"

[ssanfu]

You have to concatenate the dates.

Since the button is on the subform, you could try:

DoCmd.OpenReport stDocName, acPreview, , "([BalDate] Between #" & Me.StartDate & "# And #" & Me.EndDate & "#) And (Void <3)"

If that doesn't work, try:

DoCmd.OpenReport stDocName, acPreview, , "([BalDate] Between #" & Forms!CheckRegister!FReg.Form!StartDate & "# And #" & Forms!CheckRegister!FReg.Form!EndDate & "#) And (Void <3)"

[burrina]

Thanks, the first one did the trick. Funny how Access accepted the code when it was not being used on a subform and now not?
Not just that is on a subform but Access 2010 totally sucks. Wish I had never bought it. Have to change the code for it to work? Nevermind the subform, I don't get it!

Oh well, enough of my rant, Many thanks to you!!! That's what I get for moving it to a a main form.