UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

> Blank Continuous Subform If No Records - Not What I Want!, Office 2010    
 
   
chris-smith-shaw...
post Mar 27 2012, 09:38 PM
Post #1

UtterAccess Member
Posts: 20



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.
Go to the top of the page
 
+
 
Start new topic
Replies
strive4peace
post Mar 29 2012, 08:06 PM
Post #2

UtterAccess VIP
Posts: 20,228
From: Colorado



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

Go to the top of the page
 
+

Posts in this topic


Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 18th June 2013 - 10:07 PM