Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Switch Form Views
Richard Roesel 
    
3 years ago
How do you switch from a continuous form view(not datasheet view) to a form view showing one record at a time using vba code for access?
Adam Schwanz  @Reply  
           
3 years ago
The easiest way would be to just open a second form and then you can close the first if you want.

Open Form
Kevin Robertson  @Reply  
          
3 years ago
The easiest way would be 2 separate forms (one single, one continuous) and use a button to switch between the two.
Richard Roesel OP  @Reply  
    
3 years ago
DoCmd.RunCommand (acCmdFormView) - I think this is a continuous form view, but I don't know the accCmd????? for a single form view (not design mode)
Kevin Robertson  @Reply  
          
3 years ago
Darn Adam you beat me to it. LOL
Richard Roesel OP  @Reply  
    
3 years ago
wouldn't having two separate forms for all of the existing forms with the accompanying code bloat the project?
Adam Schwanz  @Reply  
           
3 years ago
What are you trying to do? I don't see what advantage you would have to make it into a single form, it doesn't add like more fields or anything. Normally what you would do with this kind of setup is have a continuous form to find what record you want based on a small amount of information, and then you open up a single form for that record that has all of the information on it.
Kevin Robertson  @Reply  
          
3 years ago
Not really sure why you would want a Single form and a Continuous form for all of your forms. But, considering the completely different layouts between the two it would be a lot of work to lay out each form in code.

Ask yourself, is it worth it?
Kevin Yip  @Reply  
     
3 years ago
Hi Richard, you can't switch between continuous form and single form because the two views share the same layout.  If you want to switch from the multi-record display of a continuous form to a single-record display of a single form, you have to have two separate form designs -- hence two separate forms as others have suggested.

Or you can do what I did in my old job: have one form show both the multi-record display and the single-record display.  See pictures below.  I have a subform (which could also be a continuous form) showing all the records that the users can browse.  They click on a record on the browse list, and the data from the selected record will show on a single-form view below.  That way they don't need to keep opening a separate form.  This method requires a lot more coding, because you need to "fill in" the single form with data from the selected record on the browse list.  I believe this site has a video on that: it's called Fill Form with Data, or something.
Kevin Yip  @Reply  
     
3 years ago

Richard Roesel OP  @Reply  
    
3 years ago
Thanks to all for feedback!
Richard Rost  @Reply  
          
3 years ago
To create a form that functions both as a continuous and single form, simply design it as a continuous form. Then, place duplicates of the fields you want to see in single form view in the form's header or footer. This approach essentially gives you the result you're after and is a better choice compared to using a split form.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/6/2026 6:29:54 AM. PLT: 0s