dynamic SQL based on form recordSource

[JoshuaAnthony]

Hi,

This code works for me:

strSQL = "SELECT * FROM [" & Me.RecordSource & "]"

But I can't seem to select certain fields from the recordSource. This is one of my attempts that failed:

strSQL = "SELECT [" & Me.RecordSource.[ID Number] & "], [" & Me.RecordSource.[Field1] & "] FROM [" & Me.RecordSource & "]"

Any suggestions to set me in the right direction?

Thanks,

Joshua

 

[faeryfyrre]

What is the purpose of your SQL, how are you going to use it?

Alec Doughty
Doughty Consulting P/L

"Life's a competition. Play hard, but play fair"

 

[JoshuaAnthony]

It was for exporting the dynamic recordSource of a form to an Excel file.

Somebody has actually suggested something in another forum (I was desperate for an answer!) that worked:

strSQL = "SELECT [ID Number], [Field1] FROM [" & Me.RecordSource & "]"