Results 1 to 2 of 2
  1. 06-05-2012, 04:36 AM #1
    Richie27
    Richie27 is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    Feb 2012
    Location
    Ireland
    Posts
    159

    Change form to edit mode using VBA

    I know this is probably simple but how do you change the form you are looking at to edit mode using vba?
    Reply With Quote Reply With Quote
  2. 06-05-2012, 04:39 AM #2
    Richie27
    Richie27 is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    Feb 2012
    Location
    Ireland
    Posts
    159
    My a dumb ass. Found it right after

    DoCmd.OpenForm "formName", acNormal, "", "", acFormEdit
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Use 2 listboxes to select field from main form and subform to open form in edit mode
    By xwnoob in forum Forms
    Replies: 1
    Last Post: 12-04-2011, 09:11 PM
  2. How to open form in add new mode and subform in edit/read only mode
    By JFo in forum Forms
    Replies: 2
    Last Post: 09-01-2011, 10:48 PM
  3. Opening Saved data in form in Edit mode
    By l3111 in forum Forms
    Replies: 7
    Last Post: 06-06-2011, 11:37 AM
  4. Subform shows as continuous in design mode but as datasheet in form mode??
    By Lux770 in forum Forms
    Replies: 4
    Last Post: 01-14-2011, 10:37 AM
  5. Open Form in Add Mode
    By Boreal2009 in forum Programming
    Replies: 2
    Last Post: 10-23-2009, 10:53 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums