Data not stored in Form

[Tracyice]

I am entering data in a subform that is based on a table, and the data does not appear in the subform after I enter it, but it appears in the associated table. Please help.

 

[PHV]

Check the DataEntry property of your subform.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Tracyice]

It was set to no, so i reset it to yes, and lost all of my data.

 

[MaKoTa]

Try:

Forms![My_SubForm].Refresh

Also check that the data you enter on the subform has the related data populated - eg form contains authors & subform contains books written by that author, then make sure the new book record contains the correct author relation.

Cath.

 

[Tracyice]

I checked all of this. Once I set the data entry property back to No, the data re-appeared. however, it will not allow me to save any new records.