Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    eugzl is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Nov 2021
    Posts
    68
    Thanks June7 for detail suggestions. That is my new Save event
    Code:
    Private Sub btnSaveClose_Click()
    On Error GoTo Err_Save_Click
    
    
        If Form.Dirty = True Then
            DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
            Form_fInventory.lstRequest.Requery
            Form_fInventory.lstRequest = Me.RequestID
        End If
        DoCmd.Close
        
    Exit_Save_Click:
        Exit Sub
    
    
    Err_Save_Click:
        MsgBox Err.Description
        Resume Exit_Save_Click
    
    
    End Sub
    What do you think?


    I need help to display of all values of a record on my child fRequest form when I open it by double click record on ListBox of the parent fInventory form. Now when I double click record all controls related to Device and Location keep blank. I will appreciate if you will show how it to do on a sample.
    Thanks

  2. #17
    eugzl is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Nov 2021
    Posts
    68
    I will appreciate if you will show on sample DB with code that demonstrate how to solve the problem.
    Thanks

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 12-04-2021, 03:12 PM
  2. multi-cascade combo boxes
    By eugzl in forum Access
    Replies: 9
    Last Post: 11-15-2021, 03:35 PM
  3. Replies: 3
    Last Post: 09-19-2016, 03:22 AM
  4. cascade combo boxes in continous forms
    By storm1954 in forum Forms
    Replies: 3
    Last Post: 05-10-2012, 06:00 AM
  5. Sub-Sub Form Cascade Combo Boxes
    By Huddle in forum Access
    Replies: 4
    Last Post: 03-22-2012, 01:42 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