Results 1 to 2 of 2

Thread: combo box query

  1. #1
    Join Date
    Mar 2004
    Posts
    69

    Unanswered: combo box query

    I've a continuous form showing Product_Code and Box_Type. I've got the box_Type control as a combo box which querys a table so that only box types which are compatable with the product_Code are listed. The query works apart form where I use [Forms]![Boxing]![Product_Code] to get the selected records Product code. It always comes back with the product code from the first record selected when the form opened no matter which record I access the combo box from.

  2. #2
    Join Date
    Mar 2004
    Posts
    69
    Quote Originally Posted by ISLMAN1975
    I've a continuous form showing Product_Code and Box_Type. I've got the box_Type control as a combo box which querys a table so that only box types which are compatable with the product_Code are listed. The query works apart form where I use [Forms]![Boxing]![Product_Code] to get the selected records Product code. It always comes back with the product code from the first record selected when the form opened no matter which record I access the combo box from.
    I've got it working by adding code to the OnEnter event of my Box_type combo box control to requery the control.
    Me.Box_Type.requery

Posting Permissions

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