I've been trying to create and populate a form with information obtained through a SQL query to an OBDC data source. The query works fine and I can view the the results of my query in the Data View. I did not upgrade to Designer 7 from any other "forms" creating software and I have never attempted to create a form before. I admit that I'm confused by the use of subforms. I haven't been successful in finding a "Subforms for Dummies" instruction booklet anywhere and quite frankly, the Help topics are more confusing than helpful. Certain aspects of my form work fine. My biggest difficulty is getting all of the information to flow down the page. I can display the first row of information from my query, but I never see the subsequent rows. Nothing I've tried works. I know I'm missing something very minute in the scheme of things but I'm ready to pull my hair out. I know there's an expert out there that's laughing at me, but I could use your help.
Thanks