Recent content by rpochoda

Thanks for your reply. The error has been found. There was a vestigial DISTINCT in the VBA version of the query which I didn't catch because I was only looking at the query in the form data source properties.

I have a form where the data source is a SQL query set dynamically in VBA based on entries in two unbound combo boxes. The query is a one-to-many join that selects one client's data from the one side table and one project's data from the many side table. If I copy the resulting query from...

Thanks for the help guys. But neither method worked. But I figured it out. I moved the controls on the subforms down half an inch or so, then on the tab, I move the whole subform up till the top of the subform is flush with the top of the tabs. (Who would have thought you could do this!)...

I have a form with 5 tabbed pages. Four of the pages display linked subforms. When I tab to one of these pages, the display moves to the display but drops down a bit so I can no longer see the tabs. If I want to switch to another page, I have to scroll up to see the tabs. I would like the...