Hi,<BR><BR>I have an SQL DB running using an .ADP front end. Int his I have a series of forms linked using the following code...<BR><BR>DoCmd.OpenForm "frm_company", , , "[Caller] = &#039;" & Pbl_User & "&#039;"<BR><BR>[Caller] is a field in frm_company and Pbl_User is a variable which holds the current user name. <BR><BR>The problem is, this works fine, but every now and again the form will get stuck on the previous recordset. i.e with the last criteria you specified. The only way to reset the data is to open the form in design view and change the Record Source to anythign else, then change it back and it will work again.<BR><BR>Even on closing the database, leaving it for 2 days then coming back the form is still holding the previous recordset.<BR><BR>Can anyone help??<BR><BR>Thanks,<BR>Lee