Group Choose Option on subform question?

[d9pierce1]

Hi all,


I recently added this and I cannot get it to work correctly.

=Choose([grpFilterOptions],"[TransDate] Between #" & [Forms]![frmAccountHolder].[sfrmAccountOther].[Form].[BeginningTransDate] & "# AND #" & [Forms]![frmAccountHolder].[sfrmAccountOther].[Form].[EndingTransDate] & "#","")

The primary form is frmAccountHolder
The subform is sfrmAccountOther
the form I am on in this subform is frmAccountReport

I am getting a parameter of TransDate and I cannot figure out how to get the frmAccountReport into the code above. Basically I need to figure out how to add frmAccountReport into this code as its not finding this form to get the transdate from?
Thank you all
Dave

[Welshgasman]

http://access.mvps.org/access/forms/frm0031.htm

if you are running that code in frmAccountReport then you can just use Me. ?

Is that even the correct syntax for Choose() ?
https://support.microsoft.com/en-gb/office/choose-function-fc5c184f-cb62-4ec7-a46e-38653b98f5bc

[d9pierce1]

Thanks Welshgasman,
I have tried everyone of the options in your link, most even prior to posting this.
If I enter a date in the popup "Enter Parameter" then the report opens just fine. So it has to be not finding the [TransDate] within that statement on the form.
Baffles me

[Welshgasman]

Well Transdate should be the field in the table?
What exactly are you trying to do?
I see no point of choose if you only have one choice?

[Micron]

WGM, as I see it there are 2 choices - a where clause (without the word Where) and a zls.

I cannot figure out how to get the frmAccountReport

I guess sfrmAccountOther is your subform control? Then you don't need to - it is referenced by the word Form, as in sfrmAccountOther.Form
Are you getting a parameter prompt for TransDate, or the beginning or ending dates?

My guess is that you're using an option group to make clause choices for a sql statement. If you fix the parameter prompt I don't see how you can use "" as a criteria option for dates, unless maybe your dates are really strings.

[d9pierce1]

Hi guys,
I am sorry, I didnt have a TransDate in the report Query.
Thank you all for assisting me. I got it to work just fine with adding the transdate to the query!
My BAD
Dave