Field List Not Appearing

[TeeSee]

If I were to create a RecordSource via SQL as :

Me.RecordSource = "SELECT tblTable1.item etc ..... OR
Me.RecordSource = "SELECT * FROM tblTable1 .........

Would you expect the selected fields to show up in the "Field List" so
that I could drag them onto my form? You can tell by the question that
they don't in spite of the fact I'm sure they did on a previous
application.

Any thoughts please. Thank you

 

[Chegu Tom]

Create your Query in the query designer/wizard and you will be able to drag
and drop fields

then you have two choices
save the query and call the saved query Me.RecordSource="QueryName"
or
go to the SQL option in the query editor (after you have built your query
in the designer) and copy the SQL statement and paste it into your code.
Me.RecordSource = "SELECT tblTable1.item etc

Tom