Results 1 to 3 of 3
  1. #1
    Viggen66 is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2010
    Posts
    8

    Problems with subform refresh

    Dear all



    I'm building an access database to keep track on all invoices that come to the accounting department, but I'm having some problem with the refresh of a subform.

    Owing to the fact that, there are too many vendors, and building a combobox to do a query is not a good solution, basically I want to Access to give me a list in a subform (spreadsheet mode) of the tracks of some particular vendors.

    So I have build a form, and a text box to insert the first initials of the vendor, and added this expression of the query "Like [form].[text box] & "*" "

    The query actually works, because after I type the initials of the vendor, it displays the records of the vendors, but only if I open the query like an object, the subform which is attached and main/child relation doesn't refresh.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    You would need to requery the subform in the after update event of the textbox.

    Forms!FormName.SubformControlName.Requery

    If you want it to update with each keystroke in the textbox, it would be a little trickier.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Viggen66 is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2010
    Posts
    8
    Hi pbaldy

    Thank you so much, now is working, I had already read that command of refresh, but it started running soon after I have eliminated the Master/Child relation between the text box and the subform, however there must be an explanation for this to work after it had no relation.


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

Similar Threads

  1. Replies: 4
    Last Post: 01-11-2010, 11:41 PM
  2. Refresh All goes back to First Record
    By diane802 in forum Forms
    Replies: 4
    Last Post: 12-30-2009, 04:24 PM
  3. Refresh a list box
    By Orabidoo in forum Forms
    Replies: 9
    Last Post: 04-17-2009, 04:07 PM
  4. refresh datasheet as text changes
    By mkhan in forum Forms
    Replies: 0
    Last Post: 09-06-2008, 07:46 AM
  5. My subform doesnt refresh????? HELP!
    By LiamMurphy in forum Forms
    Replies: 1
    Last Post: 03-09-2006, 09:08 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