Added Table to Form SQL: VBA not Detecting ComboBox

[Bill Bisco]

Dear all,

I have form in which I modified the record source to include another table. Because I did that, the code no longer recognizes my combo box, Plant_Combo. See below.

DoCmd.RunSQL "INSERT INTO Plant_Program (PlantID, ProgramID) VALUES (" & Me.Plant_Combo & "," & Me.ProgramID & ")"

What can I do to get my VBA Code to recognize the combo box on my form now?

Thanks,

Bill

 

[TJPoorman]

Not sure if it will make any difference, but try taking out the space in the name. Something like cboPlantID.

 

[Bill Bisco]

Thank you I will try that!