I am trying to insert mulivalues of swab locations into a table that has the same tracking number. Here is the example:

tblMainSwapLocation (Table where i get my information form)

```
Asset_ID  MAterial   Swap_Location
MFG111    Brick      Top left
MFG111    Plastic    Top right
MFG113    Wood       Center

```

tblCVLocation (Table where i want to insert information into)

```
TrackingID  Asset_ID   Swap_Location
99801       MFG111     Top left
99801       MFG111     Top right

```

I am using the following sql query to do the job, but i am having troubles with how the query should be.

```
strSQL = "Insert Into tblCVProject " & vbCrLf
strSQL = strSQL & "Values ( [pTrackNum], (SELECT MEQ.Asset_ID ,MEQ.SwabLocation" & vbCrLf
strSQL = strSQL & "FROM tblMainSwapLocation as MEQ " & vbCrLf
strSQL = strSQL & "WHERE MEQ.Asset_ID = [pAsset_ID] ))"
Debug.Print strSQL
Set qdf = dbs.CreateQueryDef(vbNullString, strSQL)
qdf.Parameters("pAssetID").Value = Me.cboAsset_Id
qdf.Parameters("pTrackNum").Value = TrackNum

```

The query in simplier form, It runs when the user clicks the save button.

```
Insert Into tblCVProject 
Values ( [pTrackNum], (SELECT MEQ.Asset_ID ,MEQ.SwabLocation, MEQ.Equipment_Name 
FROM tblMainSwapLocation as MEQ 
WHERE MEQ.Asset_ID = [pAsset_ID] ))

```

This is the error I am getting:  

[![enter image description here](https://i.stack.imgur.com/l8Kzu.png)](https://i.stack.imgur.com/l8Kzu.png)