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

[Ally1205]

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;

June7 ...Thank you! This works. However, can you (or someone) tell me how I get the listbox to update whenever I run the query? As it stands, I have to switch the form to design view and then back to form view, to get the listbox to update itself to the query results based on the search string I have entered one of the text boxes on the form.

[June7]

Try clicking the Refresh button from menu bar or write code behind form to requery the listbox. The trick is figuring out what event to put code in. Not necessary to 'run the query' and does not refresh the form or controls on it anyway. Why are you using a listbox instead of binding form to the query?

[ItsMe]

Me.ListboxName.Requery

I am glad June chimed in. I should have thought to have you post the RowSource of the listbox.

[Ally1205]

Try clicking the Refresh button from menu bar or write code behind form to requery the listbox. The trick is figuring out what event to put code in. Not necessary to 'run the query' and does not refresh the form or controls on it anyway. Why are you using a listbox instead of binding form to the query?

Thank you for your help. I couldn't find a refresh button in my menu bar....

Here is what I want to do: I have set up some text boxes to show the fields of the current record. To select the current record, I want to click on one of the records in a list of search query results. I want to run the search query based on whatever I type into one or all of four search text boxes on my form. They are called SrchFirstName, SrchLastName, SrchCity and SrchState. I want to get the search results to appear in a list where I can select one as the current record which then appears in my form. It don't particularly care how the search results list is displayed (list box, sub-form, or whatever), as long as I can click on one of the records so that it becomes the current record showing in the main area of the form, which has textboxes to display all the fields of that record.

With regards to binding the form to a query... It is currently bound to the same query I am using to search for records. I hope that is the right thing to do. I need the list box (or sub-form query results) so that if my search string finds several records that fit the search criteria, I can see all those records and select the one I'm looking for.

Thank you..
Ally1205

[June7]

I don't know A2000, but would expect Refresh to be on some menu.

However, making a main form and subform synchronize like a split form might be difficult. This means both main form and subform need to have the same RecordSource and the subform container control Master/Child links properties cannot be set. Code behind subform needs to apply additional filter to the main form based on the ID of specific record selected in subform but want the subform to still show all records that meet the criteria of the 4 search boxes. That means code in some event of the subform to set the main form Filter and FilterOn properties, maybe the subform DblClick event.

[Bob Fitz]

In A2000 Refresh is in "Views" or you can use F5

[Ally1205]

In A2000 Refresh is in "Views" or you can use F5

It's not in mine, (Ver. 9.0.2720). Pressing F5 had no effect either.
Regards,
Ally1205

[June7]

Did you try code suggestion in my previous post?

[rpeare]

edit: didn't see 2nd page

[rpeare]

in the on click event of the list box use

me.requery

to update the contents of the list box you'd have to have something like an ON EXIT event for each one of your search field:

lst_Name.requery

[Ally1205]

I don't know A2000, but would expect Refresh to be on some menu.

However, making a main form and subform synchronize like a split form might be difficult. This means both main form and subform need to have the same RecordSource and the subform container control Master/Child links properties cannot be set. Code behind subform needs to apply additional filter to the main form based on the ID of specific record selected in subform but want the subform to still show all records that meet the criteria of the 4 search boxes. That means code in some event of the subform to set the main form Filter and FilterOn properties, maybe the subform DblClick event.

Thanks for the continued advice. So it looks as though using a listbox is the best way to display the search results then. I just wish I could figure out what code to add, and where, so that the list updates when text is entered into the search boxes and so that when I click on a record in the listbox, that record shows in my form as the current record.

This YouTube video shows a similar idea which would work for me:
http://www.youtube.com/watch?v=3cJinHSSkuI
...but I could not get his code to work when I tried to reproduce his application. As soon as I type a character into the txtProperty box,
It throws up a syntax error, with the following line of code highlighted:
.Text & "*' " _ & "Or OrderNumber Like '*" & Me.txtProperty.Text & "*' " Me.lstSearchResults.RowSource = strSource

[rpeare]

use the ON EXIT property of your search boxes to requery the list box.

the way it functions be this: a user types in a string, when they hit ENTER or TAB to get away from the current search field the list box will be updated.

If you are trying to have the list box update on each character typed I would recommend against that, it's basically issuing a requery for every character typed which isn't terribly efficient, but it's definitely flashier if that's what you're going after.

[Ally1205]

Thanks, everyone for the help. I now have figured out how to achieve what I want, using a combo box.
Ally1205