Greetings all,

I've created a form for fielded searching using a query based on unbound fields on the form as criteria. The search functions as it should, allowing be to search by one or more specific fields for the desired information. My problem is in the subform that shows the results.



I have it in datasheet view and it only shows one record at a time instead of the usual full table. The user has to cycle through each record individually, kind of defeating the original purpose of having all the search results in one screen. I've looked though all the properties on the form and subform and can't figure out what needs to be changed to get the full search results in one table with multiple rows. Does anyone have any suggestions?

Thanks so much!