May i know what is the syntax to requery current form once i press a button on the form?
When i did something like that:
Me.Requery
The form will go to the first record. What i want to requery is Current Record only. For example, since every record on my form is controled by MeetingID. Let said i am open a record where MeetingID = 7. Once i press the button on the form, i want to do is requery is the MeetingID = 7 record only on the form. I don't want the form to return back to the first record.
Thanks
Fri, 02 Dec 2005 13:19:51 GMT
John Vinso #2 / 2
requery current record on the form???
On Sun, 15 Jun 2003 22:19:51 -0700, "Lim HEng Sin"
Quote:
>May i know what is the syntax to requery current form once >i press a button on the form?
>When i did something like that:
>Me.Requery
>The form will go to the first record. What i want to >requery is Current Record only.
Try Refresh instead of Requery.
John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public
requery current record on the form???