I've created a main menu form in Access 2007 called “frmSwitchboard” and embedded in that is a subform called "subfrmSwitchboard" that contains all customer orders of a certain type (Active, Paid, Unpaid). Each order has an Autonumber field called ID as it's primary key.
Linked to the ID field on the subform is a macro that should open up "frmOrders" with the relevant order number's record shown when you click the relevant ID number on the subform. If I open up the subform on its own in datasheet view and click an ID field then the relevant order form appears, great.
However, if I do this within the subform being present on the main form (frmSwitchboard) it doesn’t, I get an input box appearing with the WHERE clause from my macro showing:
The WHERE clause in the macro is: [ID]=[Forms]![subfrmswitchboard]![ID]
If I type in the order ID then the form appears but I want this nuisance not to be the case. Where have I gone wrong?
Many thanks in advance.