For lesson 18, as the user tabs through the search form, eventually the tab will end up on a control that is hidden due to the size of the form only. To overcome this problem, you could set the advanced controls visible property to false until the >> button is pressed. There should also be an OnOpen event that turns off advanced controls visibility as well. I havn't viewed the rest of the lessons yet so I appoligize if this is addressed further in the seminar.
Private Sub Form_Open(Cancel As Integer) AndOrCbo.Visible = False DoCmd.MoveSize , , 4000 End Sub
Private Sub AdvancedBtn_Click() If AdvancedBtn.Caption = ">>" Then AndOrCbo.Visible = True DoCmd.MoveSize , , 7000 AdvancedBtn.Caption = "<<" Else AndOrCbo.Visible = False DoCmd.MoveSize , , 4000 AdvancedBtn.Caption = ">>" End If End Sub