<%dim crumb crumb="DoCmd FindRecord" crumb1="Find Next DoCmd" %> Docmd FindNext in Microsoft Access
Home  Fees/Services  Access Templates  Tutorials  Access Download  Articles  Search  Forums  Blockchain Tech  Contact  Privacy  Links

DoCmd Examples - Access VBA<%response.write "
" & crumb1 %>

Docmd Macro VBA Example
Developer Home > Access Database Tutorials > DoCmd Examples<% response.write " > " & crumb %>
<% dim Gnum,Ynum Gnum="3847865006" Ynum="7164" dim Page_Type Page_Type="Prog" %>

DoCmd AddMenu
DoCmd ApplyFilter
DoCmd CancelEvent
DoCmd Close
DoCmd CopyObject
DoCmd DeleteObject
DoCmd FindRecord
DoCmd FindNext
DoCmd GotoControl
DoCmd HourGlass
DoCmd Min/Max/Restore
DoCmd OpenForm
DoCmd OpenQuery
DoCmd OpenReport
DoCmd OutputTo
DoCmd RunSQL
DoCmd SendObject
DoCmd TransferDatabase
DoCmd TransferText

Create Export Specs


Microsoft Office:
  MS Access 2003
  Access 2007
  Access 2010
  Access 2013

Docmd FindNext Method in Microsoft Access

The Access DoCmd FindNext method performs the Find Next action in Visual Basic and is used in conjunction with the FindRecord method. This method has no arguments and is called simply by  using the command: DoCmd FindNext.
Some programmers create buttons to mimic Access's built in searching tools.  In this case you would place the DoCmd FindNext in the On Click event of the command button.

To set the search criteria, use the FindRecord action. Typically, you enter a FindRecord action in a visual basic or in a macro and then use the FindNext action to find recurring records that meet your criteria. To search for records only when a certain condition is met, you can enter a conditional expression in the Condition option of the command for the FindNext action.  The conditional expression could be an if then expression or a select case command.

Note that if you use the Find Record method in from a button on your form the search will start at the 1st record and when activated again will find the same record because when you click on a command button the form looses the focus of the current records and therefore there is no current record from which to start the search.

Additional information on DoCmd.Findnext VBA code:

Docmd FindRecord
The Access DoCmd.FindRecord method performs the Find Record action in Visual Basic.This command is often used in conjunction with the Docmd.FindNext. ...

Microsoft Office:
MS Access 2003
Access 2007
Access 2010
Access 2013

Contact Information

<% Response.write "Copyright 2000-" & year(now) & " Blue Claw Database Design" %>