How Can I find the Record Source for a Field on a Form?

[TWD48]

Hi all,

I'm trying to break down an Access form that was designed by a previous employee. The form has several calculated fields and I need to figure out what parameters they are using to do the calculation. When I go to the properties, I can't tell which table or query they are using for the field. The control source is only giving me the field name. The database has hundreds of queries and looks like a query was used as the record source since the master table does not have any fields storing these values.

How can I trace the field back to the query it is using?

[usfarang]

Most likely those fields are aliases. They would come from the query if they are indeed calculated. Have you check to see if their are any form calculations?
Since calculations are normally done via the query and not on the form itself although it's not always he case.
Check and report back what you find. here are a couple of screenshots.
hth

[TWD48]

Thanks you, I looked again and I'm not finding any calculations. When I click on Expression Builder, it only shows the field name. Count in this example

[davegri]

The recordsource for the form is here:
It can be a table, query or sql string.



However, a form can change its own recordsource. Search for .recordsource in the form's code module for this possibility.
A form's current event is also a common place to calculate values for textboxes on the form.

[Micron]

Might be able to figure out if you post the expression for the calculated control. Just so we're all on the same page, a textbox (if that's what this is) has a controlsource property, not a recordsource, which is what I think your thread title is implying. The form it is on indicates the recordsource for the form and the controlsource for bound textboxes points to the field in that recordsource (table, sql statement or query). However, a calculated field cannot be bound, so there's no link between it and that table/query (i.e. it cannot be bound). That info is somewhere in the expression that performs the calculation, unless it's something like the sum of fields on the form/report. Likely that the expression contains the name of a table or query that is the basis for the calculation, unless as I've noted, it's simply a sum/addition using form fields.

[ArviLaanemets]

You have to check the form's Recordsource (activate form, and then properties). This may be either a table, a saved query, or a query defined directly in form's Recordsource. And then you can find out, which fields are present in Recordsource, either by reading recordsource query, or opening table/saved query. I'm sure there will be present a field HolPay.