Recordsetclone NOT picking up records from linked table

[CementCarver]

My code for cloning a recordset is not picking up any columns from the second linked table. Below is my code:

Dim rstEditGrower_Record As Recordset
Dim rstEditGrower_Record_Cloned As Recordset

strSQL = "Select * from FULLGROWER WHERE [MEMBER_ID] = " & Forms!frm_EDIT_CURRENT_FULLGROWER.MEMBER_ID

Set rstEditGrower_Record = db.OpenRecordset(strSQL)

Set rstEditGrower_Record_Cloned = rstEditGrower_Record.Clone



When I debug and list all the fields in my recordsetclone, none of the fields from my second table are listed.

Can anyone see what I'm doing wrong?

CementCarver

[CementCarver]

Solved it..... and here is the answer....

strSQL = "Select * from FULLGROWER inner join FULL_COMM_BREAKDOWN ON FULLGROWER.[MEMBER_ID] = FULL_COMM_BREAKDOWN.[MEMBER_ID] WHERE FULLGROWER.[MEMBER_ID] = " & Forms!frm_EDIT_CURRENT_FULLGROWER.[MEMBER_ID]

CC