Search results

Okay, I think it works now. I've entered listbox.Requery() on the click of a button, and I've replaced listbox with its name, but it says it can't find the object, strange... Any ideas ? Should I put an equal sign or sthg?

I put it all in the criteria row, It's just for one field, do I need SQL here ?

SELECT * FROM [Client Information] WHERE [Client Name] LIKE * Forms![Form com]!box1 * it still gives me a message about syntax :(

regular query, I put this in criteria: SELECT * FROM Client Information WHERE Client Name LIKE * Forms!Form com!box1 *

I am not sure what you mean, I want one search box to populate other text boxes and to filter the list box at the same time. I tried putting that in a query, it says the syntax is wrong.

Hi, I have a form with a combo box I use to lookup records in one table, and I also have a list box with all of the records from another table. Whenever I type in the combo box the name of a client the corresponding record and its fields appear, but the list box is unchanged, and does not...