Form to Table connection going haywire

[sierra467]

The items involved are:
tblClass_Writing ==>Table that stores the data from sfrmClass_Writing
sfrmClass_Writing ==>SubForm that displays and allows users to add grades
frmClass_Writing ==> Form that contains sfrmClass_Writing

I am having trouble between the subform and the table. WhenI enter a selection in the subform, it displays correctly in the sub form (for example, "Applies spelling skills in daily work". However, when I look at the table (tblClass_Writing), it is displayed as the ID number for that subcategory.

On the reverse however, when you are in a new record in the table and click on the combo arrow for the field and choose an entry like "Applies spelling skills in daily work", it displays the text "Applies spelling skills in daily work" in the feild. Then when you go to the form, frmClass_Writing, and look at the subform, sfrmClass_Writing, an empty row of data is displayed in the form.

Any help in this confusing predicament would surely help - Thanks!

 

[RuralGuy]

I suspect the BoundColumn and/or the RowSource on the Data tab is different between the two cbo's

 

[sierra467]

I looked at the Bound Column and RowSource in both the sfrm and the Table, but nothing seemed different. I ended up creating the subform from scratch instead of copying it from a similar one and it works fine. Still not sure, but it is working

Thanks for the help.

 

[RuralGuy]

Welcome to Access! Thanks for posting back with your solution.