User Profile

Collapse

Profile Sidebar

Collapse
cawkwell
cawkwell
Last Activity: Apr 1 '08, 11:08 AM
Joined: Mar 27 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • cawkwell
    replied to Filter a Combo box on a multi row form
    in Access
    Thanks for the reply.

    That works and I now understand what's happening!...
    See more | Go to post

      Leave a comment:

    • cawkwell
      started a topic Filter a Combo box on a multi row form
      in Access

      Filter a Combo box on a multi row form

      I have a form which loads a recordset.
      Within each row I want a combo box which is loaded by values from another table filtered by a value from a column on that row.

      I have set the Row Source of the combo box to
      Code:
      SELECT tblTempVIC.icID, tblTempVIC.description FROM tblTempVIC WHERE (((tblTempVIC.part_id)=Forms!frmPartInput1!Part_id)) ;
      expecting it to pull the Part_id from the current row.
      However, every...
      See more | Go to post
      No activity results to display
      Show More
      Working...