Form field list

  • Thread starter Thread starter Caroline
  • Start date Start date
C

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
 
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
Click to expand...

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
 
Back
Top