Form Visible in Design View Only

[MSprick]

I have a client form with a subform containing client status. Every thing worked fine until I added a few new calculated expressions in the underling subform query. After modifying the subform design for the new fields, I can no longer see the form in any view but the design view. (Although the background does show in the other views.) I have no idea what I changed to get this result. Both the "allow additions" and "allow edits" are set to yes. There is no populated recordset since this is a completely new database

TI

Michael

 

[Van T. Dinh]

Is the Subform's RecordSource still updateable?

If it is NOT updateable and the Subform's RecordSource (filtered by the
LinkMasterFields / LinkChildFields) returns no row, you will see a blank
Subform regardless of the AllowAdditions Property.

--
HTH
Van T. Dinh
MVP (Access)

I have a client form with a subform containing client status. Every thing

worked fine until I added a few new calculated expressions in the underling
subform query. After modifying the subform design for the new fields, I can
no longer see the form in any view but the design view. (Although the
background does show in the other views.) I have no idea what I changed to
get this result. Both the "allow additions" and "allow edits" are set to
yes. There is no populated recordset since this is a completely new
database.

 

[fredg]

I have a client form with a subform containing client status. Every thing worked fine until I added a few new calculated expressions in the underling subform query. After modifying the subform design for the new fields, I can no longer see the form in any view but the design view. (Although the background does show in the other views.) I have no idea what I changed to get this result. Both the "allow additions" and "allow edits" are set to yes. There is no populated recordset since this is a completely new database.

TIA

Michael

Michael,

Add some sample records. Try it then.

 

[MSprick]

Van

No the Recordsource is NOT updateable. So how do I fix that? I can change the recordsource but can not actually add data to the table from my form

Michael

 

[Van T. Dinh]

You will have to modify your Query to make it updateable.

See Access Help topic "When can I update data from a query?"

--
HTH
Van T. Dinh
MVP (Access)

Van,

No the Recordsource is NOT updateable. So how do I fix that? I can

change the recordsource but can not actually add data to the table from my
form.

 

[msprick]

Thank you for your insight. I've been off the internet while out of town but I ended up redesigning the DB and when I put that part together again every thing worked fine

Thanks

Michael