You have a table named "rawdata" and also a form named the same?
Suggest you change table name to tblRawData and the form name to frmRawData. Ambiguity stinks.
Your select statement should be selecting from the tblRawData and Me.cboProd1_Name has to be the combobox control name on the form.
Prod1_Name must be a text field in tblRawData.
Code:
Option Compare Database
Option Explicit
Private Sub cboProd1_Name_AfterUpdate()
Dim myCustomer As String
myCustomer = "Select * from tblRawData where ([Prod1_Name] = '" & Me.cboProd1_Name & "')"
Me!rawdata_subform.Form.RecordSource = myCustomer
Me!rawdata_subform.Form.Requery
End Sub
Also, this looks like a mainform/subform situation. If so, you don't need to set the subform recordsource on the fly.
The lookup combobox finds the Prod1_name record on the main form and the subform automatically shows any child records.
This assumes that tblRawData is defined in a one-to-many relationship with the many-side table defined as the recordsource of the subform.
If you only have one table, not a one-to-many setup, then you don't need the subform at all. Just show the found record fields on the main form.