Form based on query displaying only one of multiple query results

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Arya Kurumathur
    New Member
    • May 2013
    • 2

    #1

    Form based on query displaying only one of multiple query results

    Hi,

    I've created multiple forms based on queries. Now my issueis that even though the query that the form is based on is returning multiple records, the form is only displaying one of the records while in form view, in Datasheet View it displays all the records,

    Could someone help me out?

    Thanks,
    Arya
  • Seth Schrock
    Recognized Expert Specialist
    • Dec 2010
    • 2965

    #2
    Make sure that the form's property Navigation Buttons is set to Yes. Then go into form view and you should have navigation buttons on the bottom of the form that will allow you to click through the records. You can also create buttons to do this or use a combo box to be able to select the record you want to go to instead of having to click through every single one. Just follow the control wizard when you first add the control and it will take you through all the steps to get it setup.

    Comment

    Working...