Created one main form contains a SubForm inside. There is two buttons on the main form, indicated by
a) Save button
b) Refresh button

This button will insert data through the insert SQL string into seperate MS Access but under the same server before the data is displayed on the SubForm.

Question:
Why I need to click the Refresh button 2 to 3 times in order to obtain the latest info ? Below is my code

Any chance not to allow the few clicks exercise, on the other hand, type in few VBA codes to act as timer for delay purpose like DoEvents for example .

(Tried before the DoEvents method, however, result remain the same)