Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    287

    Unanswered: Requery Subform with new data

    This is my problem if anyone can please help...

    I have a MAIN form which has two combo boxes at the top - for NAME and STATUS.

    I have a subform within this main form that shows full data with a query dependent on the two comboboxes on the top part of the form.

    The query and forms are working as they should as the data changes if i re-run the selections, but i would like to do this live so my question is how do i link the subform to the two combo boxes above so it changes the data in the subform instantly depending on the selections.

    Any help would be appreciated.

    Thanks.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    im not sure how "The query and forms are working as they should" and yet you have a problem......

    is the sub form bound to the comboxes (ie the parent master form link is specified as the comboboxes linking to relevant fields in the sub form)

    alternatively you could use an unbound variant, and trigger a subform refresh each time either/both of the combo box changes. to do that put som code in the combobox on change event or lost focus event that forces a subform requery.. that will be something like <mysubformname>.refresh
    Last edited by healdem; 02-05-07 at 08:48.
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Quote Originally Posted by healdem
    put soem code in the combobix
    Hehe
    Sounds like (as Healdem mentioned) that the simplest answer to your "sort-of-a-question" is to perform a .requery or .refresh afterupdate.
    George
    Home | Blog

  4. #4
    Join Date
    Mar 2004
    Posts
    287
    Thanks guys! I did it by linking using parent/child and all works fine now!

    many thanks for your help and suggestions.

Posting Permissions

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