We can judge our progress by the courage of our questions and the depth of our answers, our willingness to embrace what is true rather than what feels good.
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
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Search Seminar.
