Results 1 to 3 of 3

Thread: Access 2007 subform not refresh

  1. #1
    Join Date
    Feb 2009
    Posts
    83

    Access 2007 subform not refresh

    hi
    I have problem with form in Access 2007.The form has a Main and subforms.I have created refresh macros but I can't get anything as result. With simple messages nothing is working can any one help me ?
    thank you

  2. #2
    Join Date
    Aug 2007
    Posts
    1,098

    Re: Access 2007 subform not refresh

    A subform is a form that is inserted in another form. The primary form is called the main form, and the form that is enclosed in form is called the subform. A form/subform combination is sometimes referred to as a hierarchical form, a master/detail form, or a parent/child form.check here for more Create a form that contains a subform

  3. #3
    Join Date
    Jan 2008
    Posts
    3,755

    Re: Access 2007 subform not refresh

    Subforms based on a parameter value do not refresh to reflect the data in the parameter. You create a form in Access 2007. You also create two subforms that are bound to Access queries or to stored procedures in Microsoft SQL Server. Additionally, Access 2007 populates data into the subforms by using parameter values. The first subform also sets the parameter value of the second subform. You update the first subform. In this scenario, the second subform does not update.Note This problem does not occur in Access 2003.so try this hot fix http://support.microsoft.com/kb/957690

    source blogs.msdn.com

Similar Threads

  1. Tips to improve subform performance in Access.
    By Karleen in forum Tips & Tweaks
    Replies: 2
    Last Post: 29-01-2010, 03:54 AM
  2. How to display an image icon file in subform of access 2003?
    By Superstar9 in forum Windows Software
    Replies: 3
    Last Post: 03-09-2009, 06:27 PM
  3. MS Access - How to filter subform
    By Zariah in forum Windows Software
    Replies: 3
    Last Post: 05-06-2009, 05:27 PM
  4. Form SubForm ACCESS 2007
    By streetprods in forum Software Development
    Replies: 2
    Last Post: 30-05-2009, 03:18 PM
  5. Requery of subform in MS access 2007
    By Computer_Freak in forum Tips & Tweaks
    Replies: 1
    Last Post: 16-05-2009, 09:56 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,713,520,099.21562 seconds with 17 queries