Access 2003 to 2007

[ItsMe]

The "Not Found" is an error trap for a record that is not Bookmarkable. Perhaps the switchboard applies a filter to the form when it opens it.

[Chekotah]

Switchboard code.zipYes the switchboard does have filters in it. any way to fix this. attached is the code for the switchboard.

[ItsMe]

You should be able to adjust how the form opens using the Switchboard manager. Perhaps you are asking the switchboard to open your form in Add mode. The below constants are what determine how your form opens

    ' Constants for the commands that can be executed.
    Const conCmdGotoSwitchboard = 1
    Const conCmdOpenFormAdd = 2
    Const conCmdOpenFormBrowse = 3
    Const conCmdOpenReport = 4
    Const conCmdCustomizeSwitchboard = 5
    Const conCmdExitApplication = 6
    Const conCmdRunMacro = 7
    Const conCmdRunCode = 8
    Const conCmdOpenPage = 9

I am going to guess you want an argument of 3 versus an argument of 2. You should be able to adjust the value related to the form/switchboard button via the Switchboard manager. The value for the argument is stored in a system table.

The following code looks in the table for the value of the [Argument] field and applies it to a Select Case Statement.

        ' Go to another switchboard.
        Case conCmdGotoSwitchboard
            Me.Filter = "[ItemNumber] = 0 AND [SwitchboardID]=" & rs![Argument]
           
        ' Open a form in Add mode.
        Case conCmdOpenFormAdd
            DoCmd.OpenForm rs![Argument], , , , acAdd

[Chekotah]

Thank you very much. That worked. I appreciate all the help. I am learning alot with this project. Now onto my next issue in it.