Passing value to Query Criteria from a ListBox

Hi Bonnie:
I changed the Form Name as "Menu" the result is same

Hi Michel:

I assiged the Listbox value to a text box;
List box Clic event code:

Private Sub List82_Click()
Text86.Value = List82.Column(0)
DoCmd.OpenQuery "SalesGroupManager", acViewPivotChart
End Sub

expression in Query Critaria is:
[Forms]![Text86].[Value]

the error is same " engin does not recognize [Forms]![Text86].[Value] as
Valid Field or Expression.

Atif

"bhicks11 via AccessMonster.com" wrote:

You need to not use the name Switchboard - the system uses it.

Bonnie
http://www.dataplus-svc.com

Atif wrote:
I also tried:
=[Forms]![Menu].[List28]

the result the same, Not able to recogniazed as valid field name or expression

Yes I created myself and named it as Switchboard

[quoted text clipped - 18 lines]
I pass selected option from listbox to query so that it only show the
specific region data i.e. NAE or NAW or EU.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200807/1

Try:

Forms!formname.Text86 = Forms!formname.list82.column(0)

By the way - I wouldn't use the word MENU either.

Bonnie
http://www.dataplus-svc.com

Atif wrote:
Hi Bonnie:
I changed the Form Name as "Menu" the result is same

Hi Michel:

I assiged the Listbox value to a text box;
List box Clic event code:

Private Sub List82_Click()
Text86.Value = List82.Column(0)
DoCmd.OpenQuery "SalesGroupManager", acViewPivotChart
End Sub

expression in Query Critaria is:
[Forms]![Text86].[Value]

the error is same " engin does not recognize [Forms]![Text86].[Value] as
Valid Field or Expression.

Atif

You need to not use the name Switchboard - the system uses it.

[quoted text clipped - 11 lines]
I pass selected option from listbox to query so that it only show the
specific region data i.e. NAE or NAW or EU.

--
Message posted via http://www.accessmonster.com

Thanks alot for the help.

actually it was not a Syntex problem, I was running a Select Query based on
two Crosstab queries. Now I have changed crosstab queries to select and
everything working fine.

Michel:

we can use listbox to passvalues to a Query
[Forms]![Main]![GrpMgrNo]
GrpMgrNo is a ListBox.

thanks

"Atif" wrote:

Hi Bonnie:
I changed the Form Name as "Menu" the result is same

Hi Michel:

I assiged the Listbox value to a text box;
List box Clic event code:

Private Sub List82_Click()
Text86.Value = List82.Column(0)
DoCmd.OpenQuery "SalesGroupManager", acViewPivotChart
End Sub

expression in Query Critaria is:
[Forms]![Text86].[Value]

the error is same " engin does not recognize [Forms]![Text86].[Value] as
Valid Field or Expression.

Atif

"bhicks11 via AccessMonster.com" wrote:

You need to not use the name Switchboard - the system uses it.

Bonnie
http://www.dataplus-svc.com

Atif wrote:
I also tried:
=[Forms]![Menu].[List28]

the result the same, Not able to recogniazed as valid field name or expression

Yes I created myself and named it as Switchboard

[quoted text clipped - 18 lines]
I pass selected option from listbox to query so that it only show the
specific region data i.e. NAE or NAW or EU.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200807/1

Glad to hear you have found a solution!

Bonnie
http://www.dataplus-svc.com

Atif wrote:
Thanks alot for the help.

actually it was not a Syntex problem, I was running a Select Query based on
two Crosstab queries. Now I have changed crosstab queries to select and
everything working fine.

Michel:

we can use listbox to passvalues to a Query
[Forms]![Main]![GrpMgrNo]
GrpMgrNo is a ListBox.

thanks

Hi Bonnie:
I changed the Form Name as "Menu" the result is same
[quoted text clipped - 32 lines]
I pass selected option from listbox to query so that it only show the
specific region data i.e. NAE or NAW or EU.

--
Message posted via http://www.accessmonster.com