Listbox wizard (Accss2000) "no value given for one or more parameters"

[Ally1205]

Hi,
I was trying to add a list box to my form to display the results of a query. When I use the wizard, after selecting the query and adding all the fields, and I hit "next" I get the error message "No value given for one or more parameters". Why is this?

The query works fine on its own, and I can display it in a sub-form, but not in a list box or combo box, whereupon I get the above error message.

If I populate the list box with a table, it works fine, but not when I use a query...

Any suggestions?



Thank you,
Allay

[lfpm062010]

Can you post you SQL? Right click on the query tab and select SQL View.

[ItsMe]

....The query works fine on its own, and I can display it in a sub-form, but not in a list box or combo box, whereupon I get the above error message......

This does not make sense. The message you are getting indicates there is something in one of the criteria fields that is unknown. I would be looking in the criteria fields or the query and also for an alias.

[Ally1205]

Can you post you SQL? Right click on the query tab and select SQL View.

Thanks - Do you mean the tab ibn the database window? Right-clicking on it doesn't give me a 'view SQL' option. I cannot find any way to get to SQL view...

[Ally1205]

This does not make sense. The message you are getting indicates there is something in one of the criteria fields that is unknown. I would be looking in the criteria fields or the query and also for an alias.

Here is a screencap of my query in design view:

Thanks....
Ally1205

[ItsMe]

Open the query object. There are different views..... Design View, Datasheet View, SQL View are few that I use.


.

[ItsMe]

Yup, lots of criteria that is dependant on a form name.

Make a copy of your query. YOu can right click copy and paste the object. Rename it and then remove the criteria. This could be the start of a query object you can use as a RowSource for your listbox.

[Ally1205]

Open the query object. There are different views..... Design View, Datasheet View, SQL View are few that I use.

OK - sorry - I just found how to access the SQL. Here it is:
- - - - - - - - -
SELECT CustomerT.FirstName, CustomerT.LastName, CustomerT.City, CustomerT.State
FROM CustomerT
WHERE (((CustomerT.FirstName) Like "*" & [Forms]![MainF]![SrchFirstName] & "*") AND ((CustomerT.LastName) Like "*" & [Forms]![MainF]![SrchLastName] & "*") AND ((CustomerT.City) Like "*" & [Forms]![MainF]![SrchCity] & "*") AND ((CustomerT.State) Like "*" & [Forms]![MainF]![SrchState] & "*"));

[Ally1205]

Can you post you SQL? Right click on the query tab and select SQL View.

Thanks... Pls see my reply to ItsMe.

[ItsMe]

You can paste this into the Row Source of your list box

SELECT CustomerT.FirstName, CustomerT.LastName, CustomerT.City, CustomerT.State FROM CustomerT

[Ally1205]

You can paste this into the Row Source of your list box

SELECT CustomerT.FirstName, CustomerT.LastName, CustomerT.City, CustomerT.State FROM CustomerT

Thanks, but this makes the list box display the contents of my CustomerT table. I want it to display the search results of my SearchQ query (per the SQL I posted in previous message).
Ally1205

[ItsMe]

I was thinking that you need to test for null, but with the wildcards leading and trailing, it should not be necessary. This leads me to believe a control name does not exist that is described within your Where Criteria. Not too sure what your A2000 error msg translates to for newer versions. Is the form named "MainF" open?

[June7]

The parameterized query is a saved Access query object? The listbox RowSource is referencing the query object? Then the listbox RowSource just needs to be:

SELECT * FROM SearchQ;

Then set the listbox ColumnCount and ColumnWidths properties.

[lfpm062010]

When you run your query, do you have your form "MainF" open? If not, that is why it is asking for parameters.

[Ally1205]

I was thinking that you need to test for null, but with the wildcards leading and trailing, it should not be necessary. This leads me to believe a control name does not exist that is described within your Where Criteria. Not too sure what your A2000 error msg translates to for newer versions. Is the form named "MainF" open?

Yes, it is open, because the list box is on that form.
Ally1205