Results 1 to 4 of 4

Thread: Pls Help

  1. #1
    Join Date
    Sep 2003
    Location
    Raleigh, NC
    Posts
    183

    Angry Unanswered: Pls Help

    I have unbound CombBox on my mainform. How can i link subform to Unbound combo box ?


    I have attached the database
    Attached Files Attached Files
    Skharva

  2. #2
    Join Date
    Feb 2004
    Posts
    142
    I did not download your file but the way I link an unbound combobox to a form or sub form is to create a query for the subform and in the criteria section for the desired field place this

    Forms!TheFormNameWhereComboboxIs!ComboboxName and in the afterupdate event of the combobox requery the subform.
    KC

  3. #3
    Join Date
    Sep 2003
    Location
    Raleigh, NC
    Posts
    183
    Originally posted by AZ KC
    I did not download your file but the way I link an unbound combobox to a form or sub form is to create a query for the subform and in the criteria section for the desired field place this

    Forms!TheFormNameWhereComboboxIs!ComboboxName and in the afterupdate event of the combobox requery the subform.
    I use this code in aftereven of combo to requery but it still doesn't wrk

    DoCmd.Requery "cboIPTID"

    Am i doing anythign wrong ?
    Skharva

  4. #4
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465
    Or:
    Create a control not visible and locked in the form.
    In the afterupdate event of the combobox store in that control the linked
    field using the column property.
    Link the subform with that control
    Saludos
    Norberto

Posting Permissions

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