Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2005
    Posts
    26

    Unanswered: Form Refresh after update on subform

    Hi -

    I am having trouble showing data updated in a listbox on a parent form when I return from the subform where the data is actually being updated. I have made a call to the parent form in an ClickOk event on the subform to requery the database, but it doesn't seem to be helping.

    Form_frmClientwithtabs.lstContacts.Requery

    Thanks!

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    A requery of the form only affects the control source for the form. I think you need to requery your listbox.
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Jun 2005
    Posts
    26
    Form_frmClientwithtabs.lstContacts.Requery

    I am doing a requery on the listbox, specifically. I don't recieve an error, but my listbox does not show the updated values. In my subform, I am not issuing any SQL updates. I am using the ACCESS control source objects to catch the updates. I have other subforms that are working fine - the only difference is that in those I am issuing SQL updates.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •