access forms

[biff]

I am new to Access. There is an existing Access database that I am working
with. I can see all the tables, queries and forms. Do forms pull data from
tables or are forms their own entity that have their own data source? I was
kind of under the impression that both queries and forms have to pull data
from a table but I am not sure.

I tried to find what the data source for a form was but i could not.

 

[Daniel Pineault]

Queries, Forms & Report all pull their data from tables and queries

Open the form in design mode, open the properties dialog and go to the data
tab. Then examine the 'Record Source' property -- this is where the form is
pulling its information from.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Gina Whipp]

Biff,

What the others forgot to mention is a form *can be* unbound, which no
Record Source. However, you usually see that in a form/subform situation
and the unbound main form is being used as a filter for the subform. That
*might* be the case if your form has no Record Source.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I am new to Access. There is an existing Access database that I am working
with. I can see all the tables, queries and forms. Do forms pull data from
tables or are forms their own entity that have their own data source? I was
kind of under the impression that both queries and forms have to pull data
from a table but I am not sure.

I tried to find what the data source for a form was but i could not.