Read-only form problem

[UncleBulgaria]

Hi,

I have a database in Access 2003 containing various tables of information all linked together via a common ID code using the relationship manager. Data is viewed by the database users using one main form, which has tabs for various infomation types (e.g. current and past addresses, career details, notes, etc.), with the information on each tab displayed from sub-forms.

This all worked well until I was asked to put some user-level security on the database which I did using the 'User-Level Security Wizard', creating full permission access and read-only access. The problem I now have is that when the form is viewed in read-only mode, some of the sub-forms are missing leaving just a blank space. If you go into one of these missing sub-forms direct it is also blank. If you go into design view you can see the fields that should be there ok, it is just when you are actually in Form View that it is missing.

Any ideas/help will be gratefully received!

Thanks,

Robert.

 

[missinglinq]

This is normal behavior for a form that is Read-Only and has no data in the underlying table, which sounds like the case here.

 

[UncleBulgaria]

I hadn't even thought of that as I had assumed it must be something in either the main form or sub-form's properties. Sometimes you miss the simplest of things.

Thanks for your help!

Robert.