Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557

    Unanswered: Tab Form Control...

    I have a tab form control containing listboxes. I need these list boxes to pull the data relating to the ID number of the record on the master form without me clicking a button (a refresh ability when I click next).

    Please help me out,
    JS
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

  2. #2
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557
    Okay... I dont know if I just didnt explain this well or what, but I need a tab form control to requery the list boxes inside them everytime the record changes, because that information is record sensitive. I hope this bump someone can help me :-/.

    JS
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

  3. #3
    Join Date
    Nov 2003
    Posts
    1,487
    By the sounds of it...your listboxes have the RowSource propery set to query in the lists' data. Copy the SQL then...


    In the On Current event of your form...play the query again:

    Me.myListboxName1.RowSource = "yourListbox1Query"
    Me.myListboxName2.RowSource = "yourListbox2Query"

    Whenever you select a DB navigation button, your listboxes are updated.


Posting Permissions

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