Subform Display Problem

[wchelly]

I have a main form with multiple subforms. Recently some of the subforms ONLY display if there is an existing related record in the underlying table (for the subform). If no related record exists, it doesn't display. I want it to display always (whether there is a record or not) so that if I want to add a record, I can do that. This worked correctly for many months, until now. I don't understand what has changed.

A couple of things I have changed
1/ I set the tab order
2/ I added another subform

Ideas?

 

[khodr]

Try and check if your sub form is set to allow addition in the property sheet

 

[wchelly]

Yes, I check that and it is... but I think I found my problem.

The other thing I changed....I locked down the records that were "closed" so that they could no longer be edited. But this is causing a problem with the subforms, even if it's not "closed". I don't know how to fix that aside from just removing the procedure.

 

[khodr]

You can try to put an if statement ( Form On Current Event )

If Me.YourTextBoxName = "closed" Then
Me.AllowEdits= False
Else
Me.AllowEdits = True
End If