I have a main form for clients with two continuous form subforms - One for phone numbers and one for e-mail addresses.

I entered some data directly in underlying tables, created the form and subforms, and all seemed to be working fine until I went to add a new client. The top part was empty (normal) but both subforms are blank! And I don't mean empty; they are completely blank. Not even gridlines. Just the form header and the navigation bar. And to top it off, I can not even get into the subforms. I've even shut the form down completely and re-opened it. Clients with data appear fine, but clients without data in the subforms have blank subforms.

Given that the subforms function fine as long as there is data, I have to believe that the linkages are set up right but that there is a property that I am not setting correctly.

AllowAdditions is set to True on everything. Recordsource is a linked table in both both subforms.

All tables are editable, and can be edited using table view or forms. Main form works fine, and can even enter new records no problem. It's the record-free subforms that are being the rascals.

Any suggestions? What little hair I have left can't take much more pulling.

Thank you.

let us have a look if you can zip your db and upload it here.

(IMG:style_emoticons/default/welcome2UA.gif)

Hi Chris,

blank subforms usually means that AllowAdditions is set to False ... or that you have a RecordSource based on more than one table and it does not allow creation of new records. In these cases, you can use the click event of a command button to create a record programmatically.

Have you seen this:

Contacts -- Names, Addresses, Phones, eMail, Websites, Notes
http://www.UtterAccess.com/forum/Contacts-...s-t1428638.html

Question: On the Records where Subform Records are present can you edit these Subform Records? If the answer is 'No' check the Locked/Enabled Properties of the Subform Control on the Main Form.

Having Locked = Yes

or

Locked = Yes and Enabled = 'No'

will also prevent adding New Records.

So will having the RecordSet Type set to 'Snapshot.'

Linq ;0>

This post has been edited by missinglinq: Mar 28 2012, 08:42 AM

sample forms and data as requested. just scroll to the last two records to see the pblm.

Not issues that I have, but I LOVE your tagline! I have also uploaded samples should you wish to peruse.

I don't run 2007/2010 and so can't open the attached file. Hopefully arnelgp or Chrystal will have a look at it and can figure out what's going on.

Linq ;0)>

Problem solved. while I DID check the 'allow additions' in the parent, apprently I missed checking that in the subforms. Set it to 'yes' for both subforms and all works fine.

My apologies.

Hi Chris,

great! ... and no need to apologize, others will learn from this too (IMG:style_emoticons/default/smile.gif)

> "I LOVE your tagline! I have also uploaded samples should you wish to peruse. "

thanks and thanks (IMG:style_emoticons/default/smile.gif) Have you contributed to the UtterAccess wiki? http://www.UtterAccess.com/wiki/index.php/...cess_Wiki_Index