Originally Posted by
June7
Educate me some more. If this is a live link to query in Access, what happens when you send the Excel file to client? They don't have the Access file available for the link but the Excel will show the data retrieved from the last 'update'? The 'update' is a manually triggered action on the Excel sheet? If this is the case, I don't see why a dynamic query in Access won't serve. The Excel 'update' should retrieve only the records allowed by the filter parameter. You are already doing this with a static parameter. The question is whether or not the dynamic parameter can be a reference to a form control where user inputs the filter criteria. The alternative is a popup input within the query. I have a vague recollection of addressing this very question in another thread.