Form Design: more than one detail record

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?
NubasianAsked:
Who is Participating?
 
Rick_RickardsConnect With a Mentor Commented:
Change the form's Default View (Found in the Form's Property Sheet under the 'Format' Tab) to be "Single Form" instead of "Continuous Forms" or "Data Sheet"
0
 
Stephen LappinSenior TechnologistCommented:
I am assuming that the detail in in a sub form. Change the default view on the subform to single Form.
0
 
Rick_RickardsCommented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.