Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
filter form on combo box
Adding a "breakpoint" or hitting the F8 key IAW the FAQ while in VBA editor did not produce any observable results. With VBA open, and attempting to operate the control, the same behavior results, and no "break" occurs in the code (?)- tcolson
- Post #7
- Forum: Microsoft: Access Modules (VBA Coding)
-
filter form on combo box
Private Sub cboMapMethod_AfterUpdate() Dim stDocName As String Dim stLinkCriteria As String stDocName = "Rare Points" stLinkCriteria = "[MapMethod]= " & Chr(34) & Me![cboMapMethod] & Chr(34) DoCmd.OpenForm stDocName, , , stLinkCriteria End Sub- tcolson
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
filter form on combo box
Hi, changing the even to AfterUpdate or Change results in the same behavior: selecting any one of the text values in the combo list results in "nothing happening", the "Rare Points" form doesn't open. Am I missing another line of code here? Once the text string is selected, the user releases the...- tcolson
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
filter form on combo box
I'm trying to use an unbound combo box in a switchboard form that will allow a user to open the main data entry form based upon the values presented in the combo box. cboMapMethod reads from SELECT [tlu_Map_Method].[OBJECTID], [tlu_Map_Method].[Description] FROM tlu_Map_Method; where the...- tcolson
- Thread
- Replies: 8
- Forum: Microsoft: Access Modules (VBA Coding)
