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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Different colors for different rows in list box
Until I read CajunCenturion's post, I thought you would have to write an ActiveX Control in order to do what you are asking. I like the sound of Cajun's Post though, and am interested in going to try out "OWNERDRAW" and subclassing. In my understanding, the problem with the ListBox, is that...- raylitalo
- Post #4
- Forum: Microsoft: Access Forms
-
Returning selected records in subform.
I wonder if you could just build a filter from within your popup form, and apply your filter against the control on your main form? (Just roughing my idea in here...) Sub cmdCloseForm_OnClick() Dim strSQL As String strSQL = BuildFilterFromControls() If Len(strSQL) > 0 Then...- raylitalo
- Post #7
- Forum: Microsoft: Access Forms
-
Returning selected records in subform.
I like your idea batteam, and have even used a similar approach myself in a popup subform that was supposed to help find people in the bound main form. In the subform I collected details about the person(s) being saught, and built an SQL "Where" clause and applied that to the filter of the main...- raylitalo
- Post #4
- Forum: Microsoft: Access Forms
-
Returning selected records in subform.
The way I've handled this kind of problem in the past is to build a temporary table from the subform. Set the subform's "Modal" and "Popup" Properties are True, and open the subform modally, so execution of your code waits for the form to close. In the following example, I am using DAO as my...- raylitalo
- Post #2
- Forum: Microsoft: Access Forms
