Subform not updating Free preview for web camera girls
The database structure for this example involves three tables: The main form draws its records from tbl Product, and the subform from tbl Product Supplier.
When a supplier sends a price update list, how do you filter your main form to only products from this supplier to facilitate changing all those prices? One solution is to change the Record Source of your main form, using an INNER JOIN to get the equivalent of a filter.
With an unbound combo in the form's header, you could provide a simple interface to filter products from one category.
You may also want to read our tips and tricks article Custom Form Studio - Create Custom Forms!Since many items can be replicated on the fly as you inspect, it's good to only include the minimum number of items always used directly in the master forms to keep them as small and efficient as possible.