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

 

[AccessVandal via AccessMonster.com]

If your using 2007. Someone decided to kill that. The "Field List" will not
appear anymore as it is integrated with the properties window/box, you'll
have to click it on the Ribbons "Add Existing Fields" after you create the
recordsource string.

Simply put, go manual.