Getting #Name in Continuous Form (1 Viewer)

[JGravesNBS]

I'm trying to populate a field in a continuous sub form with a filed from the main form

Find enclosed sample database IUOETest.mdb that demonstrates my issue

Open Select Shop New
Lookup Adam's Mark Hotel

Note the first four records with Active field checked

Enter Period Ending Date 10/13/15(top middle)
Notice how the Stat Date field in the continious form is populated with Period Ending Date 10/13/15 for the first four records that have the Active field checked

Click the fifth record Active, note the Stat field

Enter Check Number 1234(top right)
Notice how the Check field in the continuations form is filled with #name unrecognizable field name strCheckNo

I want the Check field to behave like the Stat field populating the Check field with Check Number from main form in all the records that have the Active field checked

Please advise

 

[jdraw]

I have looked at you attached database, and offer these comments.
-you should research and work through some tutorials on relational database concepts
-you should research Normalization
-all tables should have a Primary Key
-keys and relationships are how you represent business rules with your database

-youtube videos on relational database theory

Good luck with your project

 

[JGravesNBS]

Thank you for the references

I inherited this database and customer just wanted to add the Check Number field to behave like the Stat field.

Without redesigning this process from scratch, is there a way to get the Check field to behave like the Stat field populating the Check field with Check Number from main form in all the records that have the Active field checked?

 

[arnelgp]

can you checked if its already fixed.

 

[JGravesNBS]

I change the check field to:

Name: strCheckNo2
Control Source: Check
Check: IIf([active]=-1,[forms]![select shop new]![CheckNo],Null)

All is OK

Thanks for your help