Hello,
I'm very new to access, I started looking at it this week only
I created a form with the style "Multiple Items", which gets its data from a query.
On the form header I created a couple of comboboxes and a text box to filter the query and search for items.
I also added some bottoms to open popup forms to add items.
Everything is working, when I change the values in the comboboxes and type a search on the text box the query filters as expected.
Also when I add a new items with the popup form it adds the item to the main table and to the query.
However my problem is it doesn't update in the Form when I change the combobox or add items or type in the search. I have to manually open the query has a query window to see the results of the comboboxes. The data in the multiple item form is always the same.
Is there a bottom I can create to update the form, or for each combobox set an event to update the form to match the new query results?
Hope someone can help me out
Thanks so much
Francisco