datasheet refresh issue

[Help me]

Hello

I have a datasheet. When user clicks on a cell I have a modal window open
and then change a value which updates the table which the datasheet shows.

1. when I open the modal window the code continues after the docmd.openform
in the datasheet and it does not wait for it to return
2. other then pressing the refresh all button in the menu how can i get the
datasheet to show the change in data. ?

 

[Rui]

you have to call the 'Requery' command in the datasheet form