Home  Fees/Services  Access Templates  Tutorials  Access Download  Articles  Search  Contact  Privacy  Links

DoCmd Examples - Access VBA
Find Next DoCmd

Docmd Macro VBA Example

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.

Blue Claw Database Design is your premier source of Microsoft Access programming and database support. Both small business and department-level databases. Desktop installation as well as cloud/internet based solutions.

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

A Blue Claw Software Design Template:

Farmer's Feed Inventory Tracking Database

A Blue Claw Database Design Article:

Access Form Design Help

Blue Claw Database Design Downloadable Tutorial:
Popup Form Control Method  

Contact Information

Copyright 2000-2017 Blue Claw Database Design