Beginners who use Microsoft Access face some problems in recognizing the variation between Me Refresh and Me Requery. So let's have a look on the points of differentiation among these two branches.
Smaller Aspect:
Well both the aspects whether it's Refresh and Requery keeps the alteration done in the current record, though…
Me Requery drags all the updated data from the basic table or problem, with fresh add ups and removals.
Me Refresh just renew the data in the updated form, yet it will not explain the new or erased data.
The Longer description:
Me Requery compel the full record set (essential data) for the things to stock up. It means that all the data in one's updated form will refilled. If one's recent position is misplaced and supposedly one is situated on the record of 10 to 100 than one will find him/herself at the starting position. Basically Me Requery is almost same as its closing and renewing process is alike. Records added by the coexisting users are also available. Similarly records earlier deleted will start appearing. Requery initially start "replay the problem" that dragged the folder into its original place. It can also be used to refresh the folder in a list box or combo box.
Me Refresh keep the present data that one is using. Through it one can extract the changes made to the current records except the add ups or removal done to it. Any estimation done on the liberated fields will be redone. Record set will not be refilled by the refresh. During this one do not lost its position on the current record. Recent data added by the coexisting users could not be seen.
While opening another form or mainly a data on the updated form one should give the Me refresh command. Usually it's done to create a statement in tutorials based on the recent direction. Me Refresh is used to save the information contains in the table to make sure it prints correctly. Well one doesn't want to use the requery because it will put the user to its initial position which nobody wants.
The two other branches which mostly people gets confused with Refresh and Requery are: Repaint and Recalc.
The command of Repaint redid the current form and all its contents on the monitor. It's very useful when the statistics are running the liberated fields with the help of timers and in long time rounds. In the middle of an event when you want something to appear on the screen from time to time so that the user wouldn't be sitting ideally. The most important thing is that Repaint does not affect the information.
Re-evaluation in the form can be done by giving the command the MeRecalc. For instance, if one is presenting the terms like Unit cost in a text envelope and it's refusing from getting updated then Me Recalc can be used to update the information.
Read the views of online Certification Experts, which provide the real questions and correct answer and explanation for the students / professionals who are seeking or enhancing their level of expertise. more at certkingdom.com
