Form Visible in Design View Only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)



MSprick said:
I have a client form with a subform containing client status. Every thing
Click to expand...
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.
 
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
Click to expand...

Michael,

Add some sample records. Try it then.
 
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
 
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)



MSprick said:
Van,

No the Recordsource is NOT updateable. So how do I fix that? I can
Click to expand...
change the recordsource but can not actually add data to the table from my
form.
 
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
 
Back
Top