hi all, i have the following problem. the tables are listed below. both combo boxes are in synch and show the right category/part. the problem is when i save it, the wrong keys/unknown keys for fkCategory and fkPart are put in tblChairDetails. thanks for the help
the following code is added to the after update in cboCategories
Private Sub cboCategoryID_AfterUpdate()
On Error Resume Next
cboPartID.RowSource = "SELECT tblParts.PartName FROM" & _
" tblParts WHERE fkCategoryID = " & cboCategoryID & _
" ORDER BY PartName"
thanks for the help. when i changed it to the pkPartID, the pkPartID key number showed up in the cboPartID. The pkPartID that was saved is the correct part. how can i get the PartName from the table to show up in cboPartID instead of pkPartID. thanks