Access 2003 Forms

[Shams]

Hello Folks,
I am looking at an existing Form that extracts revenue information by first
asking for the Sales person's name (i.e. a box comes up prompting me for the
name) .

Now, I need to know if there is a way I can determine where the Form is
getting its information from . Is it getting it from a Table or a Query? I
thought I could just open the form in design view and under the properties
for one of the fields find the source for the data. Any tips will be
appreciated. Thanks.

Shams.

 

[M Skabialka]

Look at the properties for the form itself. Click on the box at the top
left corner of the form in design view to make sure there is a little black
box there. Under Properties for the form, look for the Record Source (at the
top under the All or the Data tabs). You should see a table or query name
there, or maybe an SQL statement. If it is SQL or a query click the ... to
the right to view the design and datasheet modes of the query/SQL. If there
is a table name it is looking at the table in unfiltered mode, or Properties
may show an Order By if the data is shown sorted.

Mich