Subform not retaining data...

[bellemmar]

My subform is not retaining data. I have linked the ID field on the main form to the ID field on the subform (parent/child) but when I exit the database all the subform data disappears...

 

[boblarson]

My subform is not retaining data. I have linked the ID field on the main form to the ID field on the subform (parent/child) but when I exit the database all the subform data disappears...

Your subform doesn't have its Data Entry property set to Yes instead of No does it?

 

[bellemmar]

It's set to No. Should it be Yes?

 

[boblarson]

It's set to No. Should it be Yes?

No it should be No.

 

[bellemmar]

The weirdest part is the if I go in to just the subform, the data is there. But when I go into the main form and the subform is visible, the data doesn't show.

 

[boblarson]

The weirdest part is the if I go in to just the subform, the data is there. But when I go into the main form and the subform is visible, the data doesn't show.

Sounds like the master/child links aren't set properly or you have one, or more tables included in either form which is also in the other form.

 

[vbaInet]

Can you even see any controls on the subform when it's blank?

 

[bellemmar]

Yes, I can see everything in the subform, I can enter the data and scroll through the entries i'm making. but as soon as i move to another main (parent) record and then scroll back to the previous one, all the subform entries are gone. they are still in the tables though. I've attached here.

 

[vbaInet]

You can't be linking an Autonumber field against another Autonumber field. You need to reconsider your design.