I am trying to create a report I need to access the value selected in a
listbox on one of my forms for generating the value to display. What is the
syntax I would use to access the form listbox?
The form name is frmTransactions and the list box name is lstSelectAccount

Thanks in advance for any help
Neal

Hi,
try:
Forms!frmTransactions!lstSelectAccount

you can also use expression builder in query designer to build such
expressions

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

"Neal Ostrander" <(E-Mail Removed)> wrote in message
news:ED7FB640-2A61-4646-8E0C-(E-Mail Removed)...
>I am trying to create a report I need to access the value selected in a
> listbox on one of my forms for generating the value to display. What is
> the
> syntax I would use to access the form listbox?
> The form name is frmTransactions and the list box name is lstSelectAccount
>
> Thanks in advance for any help
> Neal

Thanks, that worked.
Neal

"Alex Dybenko" wrote:

> Hi,
> try:
> Forms!frmTransactions!lstSelectAccount
>
> you can also use expression builder in query designer to build such
> expressions
>
> --
> Best regards,
> ___________
> Alex Dybenko (MVP)
> http://accessblog.net
> http://www.PointLtd.com
>
> "Neal Ostrander" <(E-Mail Removed)> wrote in message
> news:ED7FB640-2A61-4646-8E0C-(E-Mail Removed)...
> >I am trying to create a report I need to access the value selected in a
> > listbox on one of my forms for generating the value to display. What is
> > the
> > syntax I would use to access the form listbox?
> > The form name is frmTransactions and the list box name is lstSelectAccount
> >
> > Thanks in advance for any help
> > Neal
>
>