combobox beforeupdate does not work

exaccess

Registered User.
Local time
Today, 17:30
Joined
Apr 21, 2013
Messages
287
I have a multirecord continuous form that displays the results of a query. At the end of each row there is a combobox displaying a list of form names. The user selects one of these forms from the list and program fetches the detail data in that selected form corrosponding to the row where the cursor is. Now the beforeupdate or aferupdate or onclick functions do not work. Her are the properties of the combobox as JPG files and the code of the not working function.
Code:
Private Sub Sbox_AfterUpdate()
    Dim ForName As String
    Dim ParName As String
    Dim QryName As String
    MsgBox "after update combo"
    ParName = Me.Form.Name
    Select Case Me.Sbox.Value
        Case "Member"
            ForName = "NewMemberEntryFm"
            QryName = "GenMembersQy"
            Call SboxSelectForm(ForName, ParName, QryName)
        Case "Details Data"
            ForName = "Members_DetailsFm"
            QryName = "GenMembersQy"
            Call SboxSelectForm(ForName, ParName, QryName)
    End Select
End Sub
 

Attachments

  • screenshot.103.jpg
    screenshot.103.jpg
    37 KB · Views: 112
  • screenshot.104.jpg
    screenshot.104.jpg
    45.9 KB · Views: 115
  • screenshot.105.jpg
    screenshot.105.jpg
    44.3 KB · Views: 114
  • screenshot.106.jpg
    screenshot.106.jpg
    82.2 KB · Views: 116
How does not work, the event get not triggered or ??
Yes the event does not get triggered. I placed a debug message just below the line where it says:
Code:
Private Sub Sbox_AfterUpdate()
even that message is not executed.
 
Strange, create a new combobox and try if the update event in this combobox get triggered.
Or create a new form and copy the "Sbox" combobox into it, to see if the events get triggered.
Else post a stripped version of your database with some sample data + name of the form in which you've the problem.
 
Strange, create a new combobox and try if the update event in this combobox get triggered.
Or create a new form and copy the "Sbox" combobox into it, to see if the events get triggered.
Else post a stripped version of your database with some sample data + name of the form in which you've the problem.
OK I shall try them and come back.
 

Users who are viewing this thread

Back
Top Bottom