In the details of the form the data comes from test query (there are the two fields Vendor and Heat with your criteria of 'Like nz([forms].[fQA_Raw_Materials].[Vendor] and .[Heat]'.
In the form header are two combo boxes with a refresh button (me.requery) on the side.
I can select the data I want for the whichever combo box I prefer (thanks for the tip on the other question).
When I press the button it does not refresh the data after I change the selection in the combo box, but if I hit 'shift F9' my data gets updated.
I did try the Me![subform control name].Form.Requery, but the details section of the form is not a subform. It is called detail. I plugged detail in the [] section and I am getting an error. What do you suggest I do?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.