JoshuaAnthony
Programmer
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
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