Hello All!

I have a form (design shown below), which has a text box and a List Box. The list box has a Control Source as a Query I have designed. The Query runs with data from the text box. Upon initially opening the form, whatever data is in the textbox is searched properly.

For example, if enter * into the text box, change to design mode and then back to Form View, all records are shown.

If I enter smith into the text box, change to design mode and then go back to Form View, all records with "smith" are shown.

My problem is trying to re-query the data. I have a command button which I'm trying to use to "requery" the data, but I cannot get anything to update this Listbox! I've tried using the requery command on the Listbox, but I think the problem is with the query portion, not the listbox.

I've also tried to use the built-in command button to do a "form refresh" but I get an error stating that the "Refresh command is not available..."

Can someone please help with this! It's got me STUMPED!