This expression is typed incorrectly or it is too complex to be evaluated error! :(

[silkyyy]

Hello All,

I managed to establish a relationship how I wanted it. For example when I am typing a record in table 1, I get the ID pulldown PK, where I can type subrecords there. When I refresh I see all the records I typed in Table2 for that record 1 in my original table. However in Table1 when I am typing in new record for example record 2 and want to pulldown again to write my subrecords in to reflect Table2, I get this error " This expression is typed incorrectly or it is too complex to be evaluated " #Name?

Can anyone see, why its not letting me record subrecords in Table1 on line 2. But it worked on line 1, since I see 3 subrecords in my second table.

Any help is appreciated,

Thank you
Nicholas

[June7]

Don't know, I have never done data entry of child records directly with tables. I use forms. This situation calls for a form/subform arrangement.

Want to provide project for analysis? Follow instructions at bottom of my post.