Using fields from two different tables on a single form

[BlueHorizon]

Hi,

So I've searched and cannot find a way to do this: If I've added fields from different tables to a form, how can I identify which table the field came from? I couldn't find it in the Properties sheet and don't know where else I might look...

TIA,


Best,
Blue Horizon

 

[chunter33]

I believe you want to look under the Data tab of the properties list, it should be found in one of the source properties. For example, I have a combobox being populated with info from a table I could determine which table that is by looking in the Rowsource.

I'm using Access 2003 by the way.

 

[genomon]

Unless I'm missing something, you should be able to determine this from the RecordSource property in the form's property sheet?

Gluais faicilleach le cupan làn