Search results

Anyone have some idea????

Hy to all! I have a db of blood donors. I have a search form in witch I have a subform for results. When I click on search button it filters results and show them in subform. Now I need a code or something to show these results in report. I had something like: DoCmd.OpenReport "report"...

For me work this: DoCmd.OpenForm "NameOfForm", , , "[ID] = " & Me!ID Hope it will help

But I connect them with code Me.Odabir_subform.Form.RecordSource = "SELECT * FROM Odabir WHERE ID = " & Me.qryDatum_Davanja_subform.Form!ID Odabir subform is one, qryDatum_Davanja_subform is another subform. And it dosen't work. I'm not good at vba, but I think that should work. It tells...

Hy to all! I having problem with looping through records. I have a search form with two subforms: 1. list of all members, 2. list of all dates when they come to a meeting. I have a text box where I enter a date and then it filter the records in 2. subform and show me all the ID's of members...

Well, I have a db of blood donors. And I making a vba query/filter to filter the donors with specific blood type (so A, B, AB or 0). I managed to get the filtered results for a or b or ab or 0, but i can't figured out how to filter result if I select two, three or all four blood types. My code...

Thank you all.. You are great... Well, I have one more question! I managed to filter out results with query expression: IIf([Forms]![FormChoice]![Gender_M];[Gnder]="M";True) And so for female.... It works if i select checkbox for male (it show me males), and it works if I select females (it...

Can anyone tell me how to make a filter in form with multiple checkboxes??? Well, I have a db with surname, name, gender, age.... how to make a form that will show me only the records with selected chexboxes (gender=male, age=10-20....)? I'm new to this so please help!