Search results

Thanks for that example, but it's not really what I needed...you see, my checkboxes are different categories people can be part of (like: member, board member, staff...) with note that you can be in multiple categories or in none. With what you gave me, you are assigning values to the tblTemp...

I'm kinda pretty sure that it is a good string since I had this small part of code with MsgBox showing me if strSQL1 was giving me the correct stuff. So now that I was sure that my SQL string was right, insted of using MsgBox to show results, I wanted Subform to do that.

I'm kind pretty sure that it is a good string since I had this small part of code with MsgBox showing me if strSQL1 was giving me te correct stuff. So now that I was sure that my SQL string was right, insted of using MsgBox to show results, I wanted Subform to do that.

I'm still stuck with what Pat gave me last. I've tried that and it seems I can't make it right. At one point my Subform went blank after I inserted Me.subform.sourceControl part but now it seems not to show any change at all.

Still no progress...

well, you are right, that loop was here just to help me see if my strSQL1 was set up right with all those IF THENs I put up. So I had this MsgBox to prompt me if the right records were chosen... Now, I will remove this code, but only when I get my data into subform...which I couldn't do so far...

It seems that still nothing is happeneing...could it be that I have placed Me. at the wrong spot, since I'm not getting MsgBox anymore... D --------------------------------------- Me.Svi_korisnici.SourceObject = strSQL1 With rs If .RecordCount > 0 Then .MoveFirst...

......... when I do put my string as an ControlSource, still nothing happens

So, if I got it right, I should use my strSQL1 string and put it as a Subform.SourceControl=strSQL1 or is there something that I'm missing? Thanks for helping out... D

OK, I've tried that, but it seems I0m not getting it rigth... here is the part of the code that I have after couple of If thens strSQL1 = str1 & str2 Set rs = db.OpenRecordset(strSQL1) With rs If .RecordCount > 0 Then .MoveFirst Do Until .EOF...

Hi all, I have a form with around 10 checkboxes which serve as a filter option...now, when I hit my cmdFilter button it works well with a simple MsgBox !Ime showing all the filtered names...now, I want to put the results into a table tblTemp so that I could show the results in my subform. I've...