I am trying to save whatever is selected in a combobox with the following but to do that I have to find the 'ID' from one table of that selection and save it another. To start it is saying 'Too few parameters for this sql: any suggestions or examples of code that you used in saving a selection from a combo box that hooks to a different table. Thankyou I haven't gotten any replies from my last few posts and I am wondering why.

sqlAgnt = ("Select agentid from Agents where Agents.Agent = cboagent.selecteditem")


Set tbAgnt = db.OpenRecordset(sqlAgnt)