Results 1 to 3 of 3
  1. #1
    bbrazeau is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Sep 2011
    Posts
    101

    Split Form annomolly when opening passing open Args

    I have code that parses my openargs array and opens a form (as a split form) populating 3 fields with data. The problem is I can't then move to other fields and enter data (I'm limited to the one I'm on) unless I click the record in the data sheet portion of the form 1st then I can enter data in the regular form. I've tried saving the record 1st, but still it won't allow data entry. If I put a save record on the after update event of the field I'm left on it works OK, but this seems like a hack to me. Any ideas?

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,979
    Is this the default Access split form or one you have made yourself using a form a subform?
    The default version is notoriously tricky to work with if it's adapted at all.
    You might want to try out an emulated spit form designed to overcome the shortcomings of the native version
    See post 6 in this thread https://www.access-programmers.co.uk...d.php?t=294421
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    If you want help with code, post code for analysis.

    This actually sounds familiar. Now if I can just find that thread, wasn't so long ago. Think I found thread but issue Is not same. However, reinforces that split form may not be best choice for customization code.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Passing Args when opening a new form
    By StuartR in forum Forms
    Replies: 5
    Last Post: 09-03-2017, 04:10 PM
  2. Replies: 3
    Last Post: 03-11-2015, 08:05 PM
  3. Access not passing data when opening form
    By cardgage in forum Forms
    Replies: 5
    Last Post: 12-11-2012, 06:34 AM
  4. Code for button to open new form passing value
    By cptNemo in forum Programming
    Replies: 3
    Last Post: 09-13-2012, 09:46 PM
  5. Opening form with passing argument
    By eacollie in forum Forms
    Replies: 3
    Last Post: 06-03-2011, 09:37 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
  •  
Other Forums: Microsoft Office Forums