Subform disappears

[slimjen]

All, using 2016, I have a form with 2 subforms. I don't want users to be able to make changes just able to view records. I have a combo box on the main form to select the corresponding records in the subform...I set the allow additions and data entry to No in the subforms property..when the form opens or there are no corresponding records, the subform disappears..otherwise, the forms are fine and the users cannot make any changes. Can anyone give me a way I can make this form view only without the user being able to make changes pls? Thanks

[Bob Fitz]

Have you tried setting the subforms Enabled property to No

[Bob Fitz]

Have you tried setting the subforms Enabled property to No?
You may need to also change the Allow Additions amd Data Entry properties.

[Micron]

Don't know the whole picture but sometimes setting the form recordset to snapshot is enough.

[Missinglinq]

When New Records can't be added (as in AllowAdditions set to No) and there are no existing Records in the Recordset...everything disappears...including the Controls themselves.

Untested...but try changing AllowAdditions to Yes on the Forms that the Subforms are based on...and set the Locked Property to Yes on the Subform Controls.

Linq ;0)>

[slimjen]

Have you tried setting the subforms Enabled property to No?
You may need to also change the Allow Additions amd Data Entry properties.

Thanks Bob...It worked but I can't use the record selector... Close though

[Missinglinq]

If you set the Enabled back to Yes...and the Locked Property to Yes, as I suggested...you can use the Record selector but cannot Add/Edit Records.

Setting the AllowAdditions Property to Yes on the Forms that the Subforms are based on will show the Subform even if no Records exist.

Linq ;0)>

[slimjen]

If you set the Enabled back to Yes...and the Locked Property to Yes, as I suggested...you can use the Record selector but cannot Add/Edit Records.

Setting the AllowAdditions Property to Yes on the Forms that the Subforms are based on will show the Subform even if no Records exist.

Linq ;0)>

Guess my last post didn't make it last night. I did as you suggested and it worked as I needed. Thanks so much!

[Missinglinq]

Glad we could help!

Good luck with your project!

Linq ;0)>