Syntax for Fields in DAO

T

Tony Nichols

Can someone tell me the proper syntax to use when you have the same field
name from two tables in a recordset?

I have tried the following

rec![tablename]![fieldname]

and

rec![tablename].[fieldname]

Neither works!

Thanks in advance.
Tony
 
Top