Results 1 to 2 of 2
  1. #1
    burrina's Avatar
    burrina is offline VIP
    Windows 7 64bit Access 2002
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383

    Force a Main form to Requery after subform updates

    I have a main form named Categories and I use a subform for my products for that category. If user updates the Inventory then I need to requery main form so warning Inventory Levels can show up. Right now I use 2 unbound textboxes to refer to the subform for their values, this works.

    The warning works as well if the inventory has become too low. But only if I go to the next record and come back or close and reopen the form.



    I need a way to requery my main form. I tried the after update event for the unbound controls that uses the subform as its control source, that did not work.

    Subform name is AddorDeleteProducts

    Thanks in Advance,

  2. #2
    burrina's Avatar
    burrina is offline VIP
    Windows 7 64bit Access 2002
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    I am so dumb sometimes, well actually most of the time. It is working now. Code Below did the trick. Yeah For me !
    Forms!Categories.Form.Requery ' Used this on the after update event of the subform.

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

Similar Threads

  1. Replies: 10
    Last Post: 11-19-2012, 10:57 AM
  2. Requery subform after update of main form
    By gemadan96 in forum Forms
    Replies: 3
    Last Post: 10-17-2012, 02:33 PM
  3. Replies: 3
    Last Post: 04-17-2012, 10:28 AM
  4. Replies: 3
    Last Post: 10-10-2011, 06:33 PM
  5. Replies: 6
    Last Post: 01-13-2010, 02:41 PM

Tags for this Thread

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