I agree, would you please show us a screen shot of your form with the two tabs and explain what should happen. For the Where condition to work you need to have a field called "ID" in the record source of the form being called and a control called ID in the calling form (the "Me.ID" part). If both are true (and both are numeric) then the (main) form will open at the record with the right ID. Now, if you have subforms on the tab pages and those are not linked to the main form via the ID field you would get what I think you're explaining. Depending on your subforms (single form vs continuous or datasheet) you will have to add lines of code to go to the desired record in the subform. But we can't really help much without seeing what you have....
Cheers,