Requery Recordset - Redirect based upon action or cookie data
I have a webpage using three frames for employees to submit reports. The top form allows them to search thru previous entries and view the results on the right-side frame. The bottom frame has a Data entry form to submit their new report. I am using a cookie to store the user's previous report search and need to pass this so that it will be the default option on the bottom form for the select list they will use to submit a new report. It works, however, I have to requery the page so that the select list on the bottom form picks up the stored cookie in the recordset.
Any ideas on how I can have the bottom form requery based on an action (when the user clicks on 'Go' using the top form view a previous entry) or if the cookie has data? What is happening is when the user goes to the page for the first time, they have to refresh the page so that the select list will populate based upon their stored cookie.
I hope this makes sense. I'm new to using cookies and I may be going about it wrong.