Hello All, MS Access 2007 I have been working on this for months off and on. I have found many examples, videos and help but nothing really does what I need. Or maybe I am just missing a piece somewhere.
I have a form "frmPositions" with a subform "tblPositionData subform" the frmPositions has only one field on it "PSPositions" the subform has about 25 fields on it. two of them are named "DeptName" which is a combo box and the other "DeptCode". I have done this in another database but i cannot replicate it. I want the user to choose from the DeptName combo box which is based on a table named "LU_Department" a department and the DeptCode text field be populated with the coordinating Department code. So if the user choose Sign Services the code populated in the DeptCode field "806" The subform's recordsource is based on a table named "tblPositionData" I thought that I had it but the table was not populating either fields which is something different. Jim Wagner
