Results 1 to 5 of 5
  1. #1
    lefty2cox is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    May 2013
    Posts
    163

    Form Property Data Entry

    I have myForm with mySubform. I have a button on myForm that opens myForm2. I can also open myForm2 from the double click event on a field from mySubform. myForm2 is set to allow additions, edits, deletions and filters.



    The button on myForm opens myForm2 using docmd with acFormAdd and opens to a new record. The double click event on mySubForm opens myForm2 in acWindowNormal, not specified but I read it's the default. There is a where condition in this case, opening the form to a specific record using a PK from myForm and FK from myForm2.

    The button is for adding new records and the double click is for editing existing records, which I'm sure you've all gathered at this point.

    This works brilliantly through testing and for a good amount of time. Then, suddenly, the property for myForm2 switches to "dataEntry" mode causing my double click event to open to a new record instead of specific record. No error appears, it just opens to a new record. I switch it back and it works great for a while and then switches again. This has happened about 3 or 4 times now and I can't figure it out.

    I should add that I had originally created myForm2 with the dataEntry property set to yes but switched it to no soon after. I don't know if that is playing a role. Also, if it matters, myForm2 is a popup modal. Not sure if that matters as well

    Thank you.

  2. #2
    lefty2cox is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    May 2013
    Posts
    163
    I just replicated it. It happens when I bounce around to design view, depending on what window mode is open at the time I enter design mode. I haven't figured out exactly what sequence causes it yet. But maybe this info is helpful and someone knows what's happening.

    Thanks

  3. #3
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    I have also experienced properties switching when going from form view to design view and back, albeit it seems to always be about the form view property. One way to possibly overcome your issue is to pass a mode value (e.g. edit) to OpenArgs and set the applicable form properties in the opening form instead. You could also create custom form properties and set property values on open but that's somewhat harder to do.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    lefty2cox is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    May 2013
    Posts
    163
    As long as it's not me. I guess I can deal with it now that I'm aware of it. Eventually, when the form is done, I won't have to deal with it anymore.

  5. #5
    apr pillai's Avatar
    apr pillai is offline Competent Performer
    Windows 10 Access 2007
    Join Date
    May 2010
    Location
    Alappuzha, India
    Posts
    209
    myForm2 is a Popup Modal Form. Are you sure you are closing myForm2 you have opened from myForm before attempting to open by double-clicking from mySubForm. Or opens them in reverse order before closing the earlier instance at some point of the trial runs.

    Separate instances of the same Popup Form may overlap their instances and may not be visible to the unsuspecting eye. Its only a guess I didn't tried it yet.

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

Similar Threads

  1. Replies: 4
    Last Post: 01-15-2016, 04:26 PM
  2. Replies: 2
    Last Post: 12-11-2015, 02:55 PM
  3. Replies: 3
    Last Post: 02-25-2015, 04:48 PM
  4. Replies: 5
    Last Post: 03-09-2014, 07:16 PM
  5. Replies: 5
    Last Post: 08-12-2013, 12: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
  •  
Other Forums: Microsoft Office Forums