Results 1 to 2 of 2
  1. #1
    sunking_2013 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Posts
    2

    SubForm: Creating a Subform but do not want it displayed as datasheet but as form

    I created a subform in MS ACCESS 2010 on my mainform all the data from the table connected to that subform is displayed one record at a time


    in textboxes. How can I get the subform to be displayed as a subform or form not as a datasheet?

    Thanks

  2. #2
    nigelbloomy is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2012
    Posts
    51
    If you open the subform in design view, you can open the properties for the subform. In the format section one of the options is to set the default view. You can choose to have the default view as a "single form". This way your subform will show up in form view on the main form instead of as a datasheet.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 10
    Last Post: 01-29-2013, 08:59 AM
  2. Replies: 2
    Last Post: 01-21-2013, 11:28 PM
  3. Replies: 8
    Last Post: 08-26-2012, 11:11 PM
  4. Replies: 2
    Last Post: 07-19-2012, 11:25 AM
  5. Replies: 1
    Last Post: 10-13-2010, 12:40 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums