Refering to an invalid reference

[Costefran]

Can anyone help
My form opens fine and works fine until I set the allow additions to no and then I get the message that I am refering to an invalid object which shows as a subform requery on the forms open event which I debug

The reason I want to set Allow Additions to no is to prevent the user moving to another record

 

[KenReay]

Instead of using .Allowadditions for this, how about controlling (or hiding) the navigation buttons (if present), and seeting the .cycle property of the form (in form design view) to "Current Record"

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[Costefran]

Thanks

will give it a try