Invalid bracketing of name

[Access_Novice]

I am getting this error from this code: =[Forms]![Master Form]![Parents.fullName]

The problem is that the last parameter has a "." in the name. But this is because the record source is a query with two tables and both tables have a field called "Full Name." So in order to distinguish between the two, I presume Access adds the table name followed by a period as a qualifier to differentiate between the two fields with the same name.

I suppose getting around this would involve changing Full Name in one table to something different. But suppose I wanted to keep things as is, with a field called Full Name appearing in both tables. If I wanted to do that, is there a way around this?

[June7]

Where is this expression in relation to [Master Form]? Is it on a subform? Why does subform need to reference main form?

Try:

=[Forms]![Master Form]![Parents].[fullName]

[Access_Novice]

[QUOTE=June7;203391]Where is this expression in relation to [Master Form]? Is it on a subform? Why does subform need to reference main form?

Try:

=[Forms]![Master Form]![Parents].[fullName][/QUOTE

The record source was a qry and I had the expression in the criteria row. But when I went to check the record set, instead of one query, all of a sudden there were many queries listed. I don't know why. Probably had something to do with the fact that I would click the builder button (3 dots) when I went into the query to add the criteria.

I can't seem to reproduce this problem. If it happens again, I will try to keep your suggestion in mind.

You suggestion makes sense.