Viewing Locked Records

[EmmaW]

I have set my form properties 'allow no deletions/additions'

But my subform now will not show any data (the fields do not appear at all!) WHY??

 

[Atomic Shrimp]

Have you got 'Data Entry' set to 'yes'?; if you do, the form opens showing only a blank record (to permit the user to enter new data, but not view or edit the existing records) - if you combine this with 'Allow Additions' set to 'no', you get a completely blank datasheet.

 

[EmmaW]

I Haven't got data entry set to yes, my main form shows the record, but it is the subform which does not show any fields!!

 

[Atomic Shrimp]

Are we talking about the properties of the subform itself? (i.e. opening it in design view independently of the main form)

 

[EmmaW]

I mean the properties of the main form i.e not the subform are set to allow no addition/deletions, the data on the main form does appear, but the fields on the subform itself do not appear at all. The properties of the subform in design view are set to allow additions and deletions, I thought this did not matter as they are set to no on the main form!! Does that make sense??!!

 

[Atomic Shrimp]

Have you looked at the 'Data Entry' Property of the subform? (when opened in design view on its own outside of the main form)

If it's not this, then the only other this I can think of is some kind of problem with the Control Source of the subform (i.e. query criteria which result in no records found etc.)

If you want to email me the mdb (if its not too big and if its Access 97) I'll be happy to have a look.