how do i determine where a field is defined

  • Thread starter Thread starter mark kubicki
  • Start date Start date
M

mark kubicki

1) I'm very new to ACCESS
2) I've inherited a project which has on a subform the filed is defined as
[units]*[unit cost]
unit cost is not a field in the table, it seems to only exist as a field
on the form(?) (i.e., when I build and expression, it is one the list of
fields, but not in any table or query that I can see ...it must be defined
"somewhere"

how would I determine where

thanks in advance
mark
 
i.e., when I build and expression, it is one the list of
fields, but not in any table or query that I can see ...it must be
defined "somewhere"
Click to expand...

You must be mistaken on the above conclusion. Open the sub-form separately
in design mode (not from the main form).

make sure you select the form (edit->select form)

now, view the properties sheet

view->properties sheet (only do this if the properties sheet is not showing)

now, on the properties sheet, click on the data tab

What is the record source of the form? The sql is likely a query, or simply
bring up the sql designer (click on the [...]) for the record source setting
(highlight the record source setting to get the [...] button to appear to
the right).

That "field" of units * unit cost does not exist in the actual data, and it
MAKES NO SENSE to try and store this data.

So, do the above to determine if the sub-form has a query for its datasouce,
or has the actual sql stored in the form. (it will be one of the two cases).
 
Back
Top