CurrentObjectType, CurrentObjectName Properties

You can use the CurrentObjectType and CurrentObjectName properties together with the Application object to determine the type of the active database object (table, query, form, report, macro, module, data access page, server view, database diagram, or stored procedure) and the name of the active database object. The active database object is the object that has the focus or in which code is running.

Setting

The CurrentObjectType property is set by Microsoft Access to one of the following Microsoft Access intrinsic constants.

Setting	Description
acTable (0)	The active object is a table.
acQuery (1)	The active object is a query.
acForm (2)	The active object is a form.
acReport (3)	The active object is a report.
acMacro (4)	The active object is a macro.
acModule (5)	The active object is a module.
acDataAccessPage (6)	The active object is a data access page.
acServerView (7)	The active object is a server view.
acDiagram (8)	The active object is a database diagram.
acStoredProcedure (9)	The active object is a stored procedure.

The CurrentObjectName property is set by Microsoft Access to a string expression containing the name of the active object.

These properties are available only by using Visual Basic and are read-only in all views.

Remarks

The following conditions determine which object is considered the active object:

If the active object is a property sheet, command bar, menu, palette, or field list of an object, the CurrentObjectType and CurrentObjectName properties return the type and name of the underlying object.
If the active object is a pop-up form, the CurrentObjectType and CurrentObjectName properties refer to the pop-up form itself, not the form from which it was opened.
If the active object is the Database window, the CurrentObjectType and CurrentObjectName properties return the item selected in the Database window.
If no object is selected, the CurrentObjectType property returns True (–1), and the CurrentObjectName property returns a zero-length string (" ").
If the current state is ambiguous (the active object isn't a table, query, form, report, macro, or module) — for example, if a dialog box has the focus — the CurrentObjectType property returns True, and the CurrentObjectName property returns the dialog box name.

You can use these properties with the SysCmd method to determine the active object and its state (for example, if the object is open, new, or has been changed but not saved).