<div>
I am assuming that the detail in in a sub form. Change the default view on the subform to single Form.
</div>


I am assuming that the detail in in a sub form. Change the default view on the subform to single Form.

<div>
Yes, if you were to change the default view of the sub form to be &quot;Single Form&quot; it too would then display only one record at a time. &nbsp;Assuming you do not hide the navigation buttons for the sub form, however, you will be able to navigate forward and backward thru all related records in the sub form that are related to the parent, in addition to being able to add additional records related to the parent form by clicking the navigation button within the sub form that has the asterisk &quot;*&quot; character in the navigation button furthest to the right.
</div>


Yes, if you were to change the default view of the sub form to be "Single Form" it too would then display only one record at a time.  Assuming you do not hide the navigation buttons for the sub form, however, you will be able to navigate forward and backward thru all related records in the sub form that are related to the parent, in addition to being able to add additional records related to the parent form by clicking the navigation button within the sub form that has the asterisk "*" character in the navigation button furthest to the right.

<div>
<div class="content wysiwyg-content">
I created a data entry form using wizard. The data source for the form is a query &quot;Qurey1&quot;. In form view I can scroll down and see all of the detail records. I only want to see one detail record at a time. What do I need to do in design view to have the form show only 1 detail record at a time?
</div>
</div>


I created a data entry form using wizard. The data source for the form is a query "Qurey1". In form view I can scroll down and see all of the detail records. I only want to see one detail record at a time. What do I need to do in design view to have the form show only 1 detail record at a time?

Form Design: more than one detail record

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.