October 8, 2008 02:26am pdt

1. capricorn1 820,287
2. boag2000 591,176
3. LSMCons... 468,824
4. DatabaseMX 393,147
5. peter57r 300,076
6. harfang 193,752
7. jimhorn 166,190
8. wiswalld 148,653
9. hnasr 104,944
10. ldunscombe 92,086
11. koutny 89,650
12. MikeToole 87,278
13. GRayL 84,047
14. eghtebas 83,813
15. frankytee 77,464
16. TextReport 76,173
17. mbizup 67,384
18. omgang 64,850
19. LennyGray 62,632
20. Rick_Ric... 58,765
21. irudyk 57,550
22. jefftwilley 55,470
23. JDettman 54,270
24. matthews... 53,897
25. dqmq 49,181

1. capricorn1 1,308,529
2. DatabaseMX 744,360
3. LSMCons... 646,192
4. boag2000 640,266
5. peter57r 517,045
6. jefftwilley 340,537
7. harfang 336,273
8. mbizup 270,001
9. jimhorn 269,737
10. wiswalld 188,867
11. frankytee 185,705
12. GRayL 162,115
13. MikeToole 152,096
14. stevbe 146,536
15. LPurvis 121,295
16. matthews... 118,247
17. ldunscombe 113,545
18. JDettman 106,470
19. eghtebas 106,058
20. hnasr 104,944
21. dqmq 102,053
22. koutny 100,675
23. omgang 90,185
24. puppydog... 83,314
25. Rick_Ric... 78,310

07.15.2008 at 07:30AM PDT, ID: 23566193

	[x] Attachment Details

Make sure user selects item from list box before pressing edit.

Asked by linbayzak in Access Forms

Tags: Microsoft, Access, 2007, None

Hi Experts,
I want to make sure the user selects an item from the list box because if he/she does not, the debugger will pop up. I want to make a message box pop up and tell the user they need to select an item before pressing the edit button. How can I do that? Below is the code for the edit button click event. Thanks for all your help :-)

LauraStart Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:

           
           
             Private Sub cmbEdit_Click()
On Error GoTo Err_cmbEdit_Click
 
    
    
    If Me.lstSetupHistory.Column(4) = True Then
        DoCmd.OpenForm "frmSetupLogsheet", , , "ChangeoverEntry=" & lstSetupHistory, acFormEdit
    Else
        DoCmd.OpenForm "frmSetupLogsheetAnnealing", , , "ChangeoverEntry=" & lstSetupHistory, acFormEdit
    End If
    
    DoCmd.Close acForm, "frmSetupHistory"
 
    
Exit_cmbEdit_Click:
    Exit Sub
Err_cmbEdit_Click:
    MsgBox Err.Description
    Resume Exit_cmbEdit_Click
    
End Sub

           
         

Keywords: Make sure user selects item from list b…

	Title
1	Pressing spacebar in Word creates bla…
2	Terminal connection:Pressing e opens…
3	Last time mouse moved or key pressed?
4	capture 2 pressed keys
5	Computer won't boot. Gives messa…
6	Key press event

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Make sure user selects item from list box before pressing edit.

Asked by linbayzak in Access Forms

Tags: Microsoft, Access, 2007, None

About this solution