Page 3 of 3 FirstFirst 123
Results 31 to 33 of 33
  1. #31
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,530
    No problemo Joe.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  2. #32
    jmk909er is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Oct 2010
    Location
    San Diego, CA
    Posts
    39
    Found another minor glitch, I am using this command on the remarks close button

    'Closes the Remarks form and refreshes the Projects form
    Private Sub btn_close_Click()
    DoCmd.SetWarnings False
    DoCmd.Close acForm, "frmRemarksInput", acSaveNo
    Forms!frmProjectsViewer.Refresh
    DoCmd.SetWarnings False
    End Sub

    The part that is not working right is "Forms!frmProjects.Refresh" because since comments can be made from 2 forms if I am saving the comment from the other form then I would need "Forms!frmProjectsViewer.Refresh"

    This needs to refresh so that you can see the comment after the input form closes, can I put a refresh command in an event in each form, in form properties?

  3. #33
    jmk909er is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Oct 2010
    Location
    San Diego, CA
    Posts
    39
    I just fixed the glitch. On each form property "On Activate" event I put in procedure Me.Refresh and it is working fine

Page 3 of 3 FirstFirst 123
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Link Master Field and Link Child Field
    By evander in forum Forms
    Replies: 2
    Last Post: 05-25-2010, 09:13 PM
  2. Link Master Field Error
    By Lynn in forum Access
    Replies: 6
    Last Post: 04-11-2010, 01:00 PM
  3. Replies: 7
    Last Post: 02-08-2010, 12:14 PM
  4. Link ComboBox to field in a table
    By DrDebate in forum Forms
    Replies: 0
    Last Post: 04-27-2007, 08:03 AM
  5. Create the link
    By accessman2 in forum Access
    Replies: 0
    Last Post: 03-13-2006, 01:16 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