passing listbox selection to a query

J

JimL

Registered User.

Local time

Yesterday, 23:15

Joined

Jul 9, 2019

Messages

20

• Jul 9, 2019

• #1

I have created a listbox named CenterCombo which contains a field called 'LocationName1'.

I have used the following criterion in a query containing the field LocationName1: [Forms]![Center Level]![LocationName1]

Unfortunately, the query returns only the records associated with the first name in the listbox regardless of whatever field is selected.

Have I missed anything in the construction of the criterion?

Any and all help is greatly appreciated!

Thanks and Regards

JimL

 

isladogs

MVP / VIP

Local time

Today, 04:15

Joined

Jan 14, 2017

Messages

18,938

• Jul 9, 2019

• #2

Use the control name CenterCombo in the query criteria instead of the field name

 

J

JimL

Registered User.

Local time

Yesterday, 23:15

Joined

Jul 9, 2019

Messages

20

• Jul 9, 2019

• #3

Thanks so much, Isladogs! The solution works.

I am faced with the fact that the criterion passed to the query appears to remain in memory even though I have added a refresh command before the openquery command. The form needs to be closed and re-opened before a new listbox entry can be passed.

Again, much appreciated.

Regards

JimL

 

isladogs

MVP / VIP

Local time

Today, 04:15

Joined

Jan 14, 2017

Messages

18,938

• Jul 9, 2019

• #4

There should be no need to close and reopen the form.
What code are you using?

 

June7

AWF VIP

Local time

Yesterday, 19:15

Joined

Mar 9, 2014

Messages

5,999

• Jul 9, 2019

• #5

This is actually a combobox, not a listbox?

 

J

JimL

Registered User.

Local time

Yesterday, 23:15

Joined

Jul 9, 2019

Messages

20

• Jul 10, 2019

• #6

I am using the macro builder behind the button. The first action is refresh and the second action is to run the query.

Thanks

 

isladogs

MVP / VIP

Local time

Today, 04:15

Joined

Jan 14, 2017

Messages

18,938

• Jul 10, 2019

• #7

JimL said:

I am using the macro builder behind the button. The first action is refresh and the second action is to run the query.

Click to expand...

I never use macros so can only offer general comments.
Perhaps I'm being dense but I'm not sure why you are refreshing before running the query.
Try requerying (or possibly refreshing) after the query.