I want to use a datasheet/subdatasheet in a subform to show the resulting recordset formed by of a user changing different parameters on the form. In short I have got everything working except the ability to requery and display the recordset.
That is I have got the datasheet/subdatasheet showing on the subform. I have used VBA to create the SQL based on the parameters entered by the user. I have used VBA to change the Query Definition of the underlying query. All successfully. That is the datasheet shows as I want it in the subform. The Query after the Query Def change works properly. All that is missing is the ability to force Access to do a requery and show the new recordset. The statements I have tried are: Me.requery Me!subInventory.requery Me.refresh Me!subInventory.refresh I have a partial solution in that if I give up on showing the query in a subform and simply open a new window with DoCmd.OpenQuery everything works fine. Thanks for your help, Neil
