Subform doesn't load

[nepotist]

Hello Guys,

I have a form that change the visible propoerty of the subform to true once a field in the main form is filled (or once the txt field has lost focus). I have two copies of this application one works fine the other doesn't.

The application which works fine has 753 records in one of the table and the one that doesn't work has 755 records two additional records. Rest of the stuff is the same.

The problem with the one that isn't working is this:
Once I update the txtfield and The subform does show up but I can see the fields to add data (I can see the Field heading, but not the actual fields where I can type in the new data).

I have tried to update the table in the application what works fine with the updated table, once the updated table is imported the subform as the same way.

Could someone please tell me what is happening. I need to turn this application tomorrow.

Thank you

[HiTechCoach]

If you can't add data to a sub form because it is blank with only header I would first check to be sure the form's record source is updateable.


Is you application split into a front end and back end?

See: Splitting your Access database into application and data (http://www.hitechcoach.com/index.php?option=com_content&view=article&id=35:split-your-access-database-into-application-anddata&catid=65:split-database)

[nepotist]

The Main form is used to add new projects. Once a filed in the main form is updated the Subform is visible with blank fields to fill in (The header is shown though).

I have also tried to replace the table in question in the working version, but once the table is replaced the application doesn't work the way it should.
I have provided the screen shot of the working and nonworking version. Hope it help to understand better.

Non-Working Version

http://postimage.org/image/sf4t0315b/
http://postimage.org/image/sf4t0315b/

Working Version
http://postimage.org/image/st64zol8v/
http://postimage.org/image/st64zol8v/

The problem is that the empty fields do not showup in the non working version

I have tried to add data manually to the version that is working. It gives me a error saying
"One or more values are prohibited by the validation rule '0' set fro 'tblxyz. SegID'
. Enter a value that the expression for this field can accept."

The value that I am entering in the field is "373.2" which is a valid value. I am not sure why I am getting this error.

My application isn't split.

Any help would be greatly appreciated.

Thank you

[HiTechCoach]

The Non-Working Version is cause nu the sun form not being updateable. This could be the record source or the sub form is set to not allow additions.

Since it may be at the table level also compare the table design and relationships.


Hopefully yur application is split. If it is then relink the Non-Working Version's front end to the back end that works. This will help you determine is it is in the form level (app/front end) or the table level (data/back end