You can use the Command function to return the argument portion of the command line used to launch Microsoft Access.
Command
When Microsoft Access is launched from the command line, any portion of the command line that follows the /Cmd option is passed to the program as the command-line argument. You can use the Command function to return the argument that has been passed.
To change a command-line argument once a database has been opened, click Options on the Tools menu. On the Module tab of the Options dialog box, enter a new argument in the Command Line Arguments box. The Command function will now return the new argument you have entered.
When the Command function is used anywhere other than in Visual Basic code in a module, you must include empty parentheses after the function. For example, to use the Command function in a text box on a form, you would set the ControlSource property to an expression like the following.
= Command()
The following example shows how to launch Microsoft Access with a command-line argument, then shows how to return the value of this argument using the Command function.
To test this example, click the Windows Start Menu and choose Run. Type the following in the Run dialog box, on a single line.
C:\Msoffice\Access\Msaccess.exe C:\Msoffice\Access\Samples\Northwind.mdb å/cmd "Orders"
Next, open a new module in the Northwind sample database and add the following function.
Function CheckCommandLine()
' Check value returned by Command function.
If Command = "Orders" Then
DoCmd.OpenForm "Orders"
ElseIf Command = "Employees" Then
DoCmd.OpenForm "Employees"
Else
Exit Function
End IfFunction
When you call this function, Microsoft Access will open the Orders form.
You can create a macro named AutoExec to call this function automatically when the database is opened.