Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2004
    Posts
    41

    Unanswered: What is the best way

    I need a sub form refreshed with new filters depending on a main form combo box selection. Need a code to do this easily, can anyone help?

    Plus, depending on what the main combo has, a second query should be
    launched in the background, and feed some text boxes within the subform
    along with the main query refresh.

    I can give more details as needed, this is very important to me, Thank you all.

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    Generaly (but not always) a subform is related (linked) to data within the main Form of where is resides. By changing the subform control Link Child Fields and the Link Master Fields properties, then a subform Requery (all via code) in the OnClick event of your ComboBox will usually do the trick. It all depends on what you are really trying to accomplish. Inserting data within the subform can also be accomplished providing the privileges are available.

    To receive better results from your post, it may be a good idea to provide a small sample DB of what you are trying to accomplish and allow members get a good grasp of your needs. The sample will most always be returned with the results you desire.


  3. #3
    Join Date
    Dec 2004
    Posts
    41
    I will post an example shortly, thanks man can't thank you enough.

Posting Permissions

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