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