I am trying to create a form with a table in it. The table and the form pull from the same table. My reasoning behind this is for people who are entering new records can see existing records and don't create a duplicate. After I put the datasheet in the form and opened form view I can only see the record that the form is showing. Is there any way to see all of the records in the form all at once regardless of what record I am on?
Thanks