Formula in table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Not sure where to post this question, so here goes. Is it possible to enter
a formula, say "=[Child44].[Form]![TestField]" in a field in a table and when
the form that is linked to that table opens, it would look to the "Child44"
subform on that screen and bring in that value? In other words, store the
formula in the table instead of in the form.

Thanks,
 
Steve

No. You're thinking about spreadsheets, in which you can embed formulas in
cells. Access is a relational database, and doesn't have that capability.

"Do the math" in either a query based on the table, or in a form based on
the table. ... or do it in the query and base your form on the query.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top