Dear all
I'm building an access database to keep track on all invoices that come to the accounting department, but I'm having some problem with the refresh of a subform.
Owing to the fact that, there are too many vendors, and building a combobox to do a query is not a good solution, basically I want to Access to give me a list in a subform (spreadsheet mode) of the tracks of some particular vendors.
So I have build a form, and a text box to insert the first initials of the vendor, and added this expression of the query "Like [form].[text box] & "*" "
The query actually works, because after I type the initials of the vendor, it displays the records of the vendors, but only if I open the query like an object, the subform which is attached and main/child relation doesn't refresh.