Results 1 to 3 of 3
  1. #1
    templeowls is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2019
    Posts
    305

    Suggestions on how best to design a 'pop-up subform'

    I was hoping to see if anyone could provide an online guide or just general suggestions on how to accomplish the below.

    I've got a form full of customer purchases. The form looks at one purchase/record at a time. I was hoping that, while on a purchase, I could open a pop-up form from the main form via a command, and the pop-up form is directly synced with the record that I'm currently on in the main form. Even better, when coding this pop-up form, it would be ideal if things like 'Me.Customer' would refer directly to the mainform. Not sure if that's even possible though.

    Again, any tips of guides would be great. I found some information on subforms but this pop-up form wouldn't be embedded in the main form. It would be a seperate pop-up form so its not really a subform.

    Thanks

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Perhaps you could show us your tables and relationships and from that described what it is that the "subform" would do. What it would involve. What would trigger its use/appearance....

  3. #3
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    It reads very much like a form/subform relationship where the subform isn't a "popup" form. No idea what this popup form should show though, so maybe it's not needed at all. Are you sure that you need a separate form that can easily get out of sync instead of just showing/hiding a subform on a main form that lets Access do all the heavy lifting?
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Database design suggestions for Student and Classes
    By tgould in forum Database Design
    Replies: 3
    Last Post: 01-08-2017, 02:29 PM
  2. Replies: 8
    Last Post: 07-24-2014, 11:11 PM
  3. Need design suggestions for indexed-no duplicates field
    By jax1000rr in forum Database Design
    Replies: 3
    Last Post: 01-29-2013, 06:42 AM
  4. Examiner Database Design Suggestions
    By seth1685 in forum Database Design
    Replies: 1
    Last Post: 01-05-2012, 10:11 AM
  5. Suggestions for Form Design
    By KrisDdb in forum Forms
    Replies: 2
    Last Post: 12-08-2011, 02:31 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