Here what I am trying to do...
I have a form that employees enter information to find out yeild.
Three of the values are in the same table but cavities are pulled from another based on the previous part entered through VBS.
Private Sub Form_Current()
Cavities = Die_No.Column(1)
Die_No.RowSource = "SELECT DIE.Die_No, DIE.Die_Cavities FROM DIE INNER JOIN PART_DIE ON DIE.Die_No = PART_DIE.Die_No WHERE (((PART_DIE.Part_No)=[Forms]![frmMain]![Part_No]))"
I get an error when I try to run it. I didn't build this database just inherited it and the one that built it is more advance than myself.