Search results

BAM! That's it! I didn't know it was supposed to be like that. Thank you! :D

I tried removing all ordering functions in all elements of the database, but the Record Source of the Report is the primary table.

I've already tried that method. I can search First Name with it, but I cannot search Last Name or first and last name. I get error: "Run-time error '3075': Missing ), ], or Item in query expression '([Last Name] Like "*NAMEWITHHELD*"'." and it highlights "Reports![Students Report].Filter =...

Right now I have it almost the way I want it. I can search by First Name and it will filter the report correctly. I can search by Last name and it will filter the report correctly. But I cannot search by both first and last name. It has something to do with AND. I have tried many variations of...

I hate to bother you again, but this is for everyone out there too. I've decided it would be better to take a different approach than queries. Instead of using a query, I want to filter the report using VBA and SQL. I found a tutorial here that takes this approach. However, I am having...

Never mind. I figured it out. Thank you so much for all of your friendly help! Have a wonderful day!

That's not exactly what I meant. I meant I want the report to requery without closing it or the form. Also, how do I retrieve all of the records in the report by leaving the Combo Box blank?

Brilliant! That was definitely the problem. It works now. It makes sense to me too. I just couldn't figure out the problem on my own. Thank you for your help! Now how do I update the report every time I press the button control on the form?

SELECT Students.[First Name], Students.[Last Name], Students.DOB, Students.Sex, Students.Ethnicity, Students.Diagnosis, Students.[Street 1], Students.County, Students.City, Students.State, Students.Zip, Students.[Resides With] FROM Students WHERE (((Students.[First Name])=[Forms]![Report...

The Record Source is ReportGenQ, which is a query that contains the First Name field from the Students table. The criteria for the First Name field in ReportGenQ is [Forms]![Report Generator]![FName]. Report Generator is the form.

I've tried that method. It makes no difference. The results still come up as zero.

The RowSource of the Combo Box in the form is SELECT Students.ID, Students.[First Name] FROM Students ORDER BY Students.[First Name];

I've done quite a bit of editing. At the moment, I have it so that when I open the query and enter a criteria into the prompt, I get the proper results. The same happens when I open the report. However, when I select the criteria from the form combobox that is linked to the specified field in...

I figured out that POAH05 is a unique identifier under the primary key in my main table. The immediate window returns the unique identifier related to the First Name I choose every time I run the report filter. What do I do with this information?

Ah! Yes! I didn't know what the immediate window was. The code is POAH05.

I added it after the code. There is nothing different. It still just opens the report with all of the records.

It still is not working. I'm thinking I'm doing something wrong beyond the code. I've checked the names of everything and they all check out. Do you think it might be because I'm using a combobox as a filter source?

Sketchin, It's still not filtering the records. When I press the command button on the form, all of the records show up in the report. I'm sure I'm just making a dumb mistake, but I can't figure what it is.

BlueIshDan, thank you for your reply. I tried putting the brackets in the code, but there was no change in behavior.

I'm trying to use a command button in a form to filter and open a report. I am able to get it to open the report, but I cannot get it to filter the report based on a combobox in the form. I've tried every combination of code I could think of and find. Here is what I currently have: Private Sub...