Form field list

[Caroline]

Hello,
I created a form a while ago and I believe it was based on queries because I
cannot see the option "Show all tables" in the fields list pane when I want
to edit my form (add fields).
I cannot find which query(ies) it was built from and I want to add fields,
which I added to a table. How do I pull those fields into my form? Can I
change my form to pull from tables rather than queries?
Or... how do I add query fields to the field list pane?
Thanks,
Caroline

 

[Keven Denen]

Hello,
I created a form a while ago and I believe it was based on queries because I
cannot see the option "Show all tables" in the fields list pane when I want
to edit my form (add fields).
I cannot find which query(ies) it was built from and I want to add fields,
which I added to a table. How do I pull those fields into my form? Can I
change my form to pull from tables rather than queries?
Or... how do I add query fields to the field list pane?
Thanks,
Caroline

Check the Record Source property on the form, this will tell you where
the form is getting it's data from. If you added fields to the table
but they aren't showing up in your field list, chances are you set the
Record Source to a query and you'll need to modify that query to get
access to those new fields.

Keven Denen

 

[Caroline]

Nevermind, found a solution...> Caroline