Show all records on split form

[foshizzle]

Hi, This is probably an easy fix...

I created a split form.
My main form is just a form, based off of tblBlotter.
The subform is based off a query, which is the based off the same tblBlotter. (Not sure if this is proper - maybe I just need the table?)

I have a link master and link child field set to ID. When I open the form "subBlotterHistory", it opens and shows as a new record only. I want it to show ALL records on the query subform and be able to scroll up, down and edit.

What am I missing? Attached is a sample w bogus data.
Thanks

 

[EternalMyrtle]

For some reason I cannot open your database. I am confused are you talking about a split form or a subform?? They are different. If you are using a split form you do not need to include a subform at all or link master/child fields.

If it is a subform, why would the child field be ID?? It should be the FK to the tblBlotter in your subform's table (so, BlotterID or something). It should not be the FK of the subform's table). You can use a query for the subform but you can just use the subform's table. The main form and subform shouldn't be from the same table.

Also make sure that the subform is not set to Data Entry in the data properties. That will only allow new records to be created and not show all the data.

 

[foshizzle]

Ah ha!
Thanks, that was it.

I think what I was trying to say was make a form that mimics the split form option that Access lets you create. When I used their template, I could not view it in the navigation menu.

This was the answer

If it is a subform, why would the child field be ID?? It should be the FK to the tblBlotter in your subform's table (so, BlotterID or something). It should not be the FK of the subform's table). You can use a query for the subform but you can just use the subform's table. The main form and subform shouldn't be from the same table.

Not sure why the DB wouldn't open though..

Thanks again!

 

[EternalMyrtle]

Okay, glad you figured it out.

BTW, I meant that the child field should not be the PK of your subform's table. Hope you got that anyway. If you solved the problem, you probably did.