[AccessD] My form has a little problem

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Wed Jan 18 20:20:18 CST 2006


"Should I be adding an After Update event procedure to my unbound combo 
box - to set the focus on the button to get the student information form? "

That's the first thing I'd try, Tina.

Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com

Tina Norris Fields wrote:
> Hi all,
>
> I have a form for either creating a new student profile, or editing an 
> existing one.  To create a new profile, the user clicks a button that 
> opens the student information form in add mode.  To edit an existing 
> profile, the user selects the student's name from an unbound combo box, 
> and then clicks the button to open the student information form for that 
> student in edit mode.
>
> When I first made this little form, it all worked well, but it no longer 
> works just right.  If I select a student's name from the combo box, and 
> I try to click the button to open the student information fomr, the 
> button does not get the focus - it does not respond.  If I wait around 
> for a while, eventually the button will let me click it.  If I tab out 
> of the combo box, the focus will shift to the the buttons in their 
> established tab sequence.  
>
> I remember there have been heated discussions on this list about unbound 
> controls.  I am ready to learn - do I have a problem because I'm using 
> an unbound control?  
>
> This is what my button does when I can get it clicked:
> ==========
> Private Sub cmdEditExistingStudentProfile_Click()
> On Error GoTo Err_cmdEditExistingStudentProfile_Click
>
>     Dim stDocName As String
>     Dim stLinkCriteria As String
>
>     stDocName = "frmStudentInformation"
>     stLinkCriteria = "[StuID]=" & Me![cboFindStudent]
>     DoCmd.OpenForm stDocName, , , stLinkCriteria
>
> Exit_cmdEditExistingStudentProfile_Click:
>     Exit Sub
>
> Err_cmdEditExistingStudentProfile_Click:
>     MsgBox Err.Description
>     Resume Exit_cmdEditExistingStudentProfile_Click
>    
> End Sub
> ===========
>
> Should I be adding an After Update event procedure to my unbound combo 
> box - to set the focus on the button to get the student information form?
>
> Thanks for whatever lessons you will send my way.
>
> Tina
>
>   

-- 
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com




More information about the AccessD mailing list