Results 1 to 5 of 5
  1. #1
    cap.zadi is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2011
    Location
    KSA
    Posts
    481

    Pop Up a subform after entering the value in a field.

    Hi Every one.

    Nice weekend.



    May some one can help for the below requirements.

    TblTransaction
    TrnNo (PK)
    Date
    GoodQty
    RejectQty
    Reason1 (Reject Reasons from 1- others)
    Reason2
    Reason3
    Reason4
    Others

    There is a main form "FrmTransactions" to input the required data whereas if there is any rejected qty and entered any value in rejectqty field then a subform "SfrmRejects" shall popup to allow for the entry of reasons as fields are given above.
    and also the the total qty given in reject reason fields should be always equal to the qty in "RejectQty" if any.

    Kindly advise.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    If you have 4 fields for reasons on the same table, why do you need a popup form? The fields can be on the same form.

    Could there ever be a need for 5 (or more) reasons? This table structure is not normalized. That would require a related table where each reason is entered as a separate record.

    Use form BeforeUpdate event to validate data.
    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.

  3. #3
    cap.zadi is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2011
    Location
    KSA
    Posts
    481
    Hi Thanks for the feedback.

    Actually there's many other fields as well and most of the time there is no any rejects so its just useless to show up those fields.

    So any help with the code would be appreciated.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    You will encounter complication. You start edit of record on one form and then want to open another form to edit the same record. A record cannot be edited in two locations. Arrange controls on form so the less used ones are not accessed as frequently. Use a Tab control to organize them.
    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.

  5. #5
    cap.zadi is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2011
    Location
    KSA
    Posts
    481
    Hi

    Yeah you are right to use tab controls to do so.

    Thanks

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

Similar Threads

  1. Replies: 14
    Last Post: 12-12-2017, 01:32 PM
  2. Replies: 1
    Last Post: 06-30-2016, 04:57 PM
  3. Replies: 2
    Last Post: 03-18-2016, 09:34 AM
  4. Error entering new record on a subform
    By AccessNewb11 in forum Access
    Replies: 1
    Last Post: 07-24-2014, 11:49 AM
  5. Replies: 4
    Last Post: 04-07-2011, 03:39 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