SUB FORM NOT VISIBLE

Question

I don't know why but when I have one of my forms displayed in Design Form, a BLANK rectangle space representing the sub form is present, but upon turning back to Form View and again returning back to Design View leads to have the subform then visible.

Furthermore, in the Form View the sub form is ALWAYS a BLANK rectangle space.

Please c if one of u xperts could help me in this regard.

Thanxin advance.

---

Best Regards, Faraz A Qureshi

Answer 1

That is typical form/subform behavior (seeing the blank rectangle in design view) as it normally happens when you have the main form open and then perhaps do something with it and then go to design view.  The way to ensure it always opens with the subform showing is to just close the form and then reopen in design view.

As for the subform not showing anything, that will happen if the record source the subform has does not have any records to return and the record source is non-updatable so therefore you can't add any records through the form.  The key to fixing that is to make sure you have AllowAdditions and AllowEdits set to yes for the main form and subform and then make sure your query underlying the subform is updatable.  See here for why a query is made non-updatable:

http://allenbrowne.com/ser-61.html

---

Bob Larson, Former Access MVP (2008-2010) http://www.btabdevelopment.com (free Access tools, tutorials, and samples)

Answer 2

Here is a work around to display the info from subform [ but not edit it ]

Make the subform as usual - dont worry if it is blank.

on main form create a text box

in the textbox it self type this   =[Sub_Form_Name].[Form]![Sub_Form_Field]

Replace:

  Sub_Form_Name: with your subforms name

 Sub_Form_Field: with your sub form's field

This will display the information from a form which is not editable, because the query does not MS access criteria for editable forms

my first write up  :)

also I am not a programmer and do not have any official training

Answer 3

Might be something wrong with the form, so let's try Compact & Repair after you make a back-up of our database.

---

--

Gina Whipp

Microsoft MVP (Access)

Please post all replies to the forum where everyone can benefit.