mateo107
Dec 4th, 2005, 03:25 PM
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!
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!