Hi Guys,
I am working with a simple production database. I have built a form in which customer selects the month and in a sub form Or Sub query the results are displayed. The query is getting the results based on Sdate & Edate user input variables. Query is working fine.
My problem is as I update the value in user input boxes, the sub-query on the form does not update. I have tried running me.requery on field update procedures but it just works for the first time (when I add the code). Sorry when ever Shifting from form view to design view & back to form view the Subquery updates and works fine. Just need to do it without going into design view and come back.
How can I do this. Please help and guide.
Thanks and regards
Deepak Gupta