It sounds like perhaps what you are describing is when creating a new record, the embedded report of related records, is not displaying as you're expecting. This is because the new record (in the process of being created) hasn't saved, thus doesn't have an ID under the hood. The related records can't be displayed until their parent record is saved linking their IDs together.
Here are some things worth considering:
- You may check a box in your formula url by setting the field to 1 (true)
- e.g. &_fid_999=1 (where 999 is the ID of the checkbox)
- In Table Settings -> Forms -> Properties tab check "Show save & keep working choice" as Mark eluded
- Use Form Rules instead, to check the box when appropriate
- Consider a formula checkbox instead (that self checks when conditions are met)?
- Look into Pipelines to perform checking a box after the record is saved
- The latter seems like overkill for this situation
For me, it's unclear which table stores the checkbox data from your example. And what specifically it represents.
Anyway, hope that helps!
------------------------------
Brian Seymour
------------------------------