Access 2003 Forms

  • Thread starter Thread starter Shams
  • Start date Start date
S

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