ACC1x: Setting Form's Dynaset Property Puts Bookmark at EOF

 Last reviewed: June 8, 1997
Article ID: Q90850
The information in this article applies to:
  • Microsoft Access versions 1.0 and 1.1

SUMMARY

In Access Basic, you can make a copy of the dynaset that a form may currently be using for data manipulation.

The syntax to accomplish this is: 

   Dim MyDB as Database
   Dim MyDyn as Dynaset
   Set MyDB = OpenDatabase("NWIND.MDB")
   Set MyDyn = Forms!Categories.Dynaset
In this case, you may assume that the bookmark is at the beginning of the Categories dynaset. However, the bookmark is at the end-of-file (EOF) marker. In fact, after a variable is set to the dynaset of a form, there is no current record because the bookmark is actually at the EOF marker.

MORE INFORMATION

Before doing any further actions, the two dynasets should either be synchronized or the bookmark should be set to the first record. This is done with the following statement: 

   MyDyn.Bookmark = Forms!Categories.Bookmark  ' Synch dynasets.

   -or-

   MyDyn.MoveFirst   ' Move to first record.
After one of these statements has been issued, there will be a current record and the bookmark will be pointing at this current record.

REFERENCES

Microsoft Access "Introduction to Programming," version 1.0, Chapter 8

Keywords : kbprg PgmObj
Version : 1.0 1.10
Platform : WINDOWS
Hardware : X86
Issue type : kbinfo

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: June 8, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.