I am trying to requery a split form views datasheet, can you anyone help with the code?
Thanks
I am trying to requery a split form views datasheet, can you anyone help with the code?
Thanks
Requery the form:
From the form:
Me.Requery
From another form:
Forms!FormNameHere.Requery
The datasheet and the single view are all integrated in the form and requerying the form would be the key to requerying the datasheet. The single view is tightly controlled by the datasheet so it would not matter. However, you might need to save the PK in a variable so you can go back to that record so the single view would be showing the same record after the requery.