jwessner
Last Activity: Jan 5 '09, 01:44 PM
Joined: Dec 9 '08
Location:
-
I actually thought of hiding the subform fsubAllocations before if there was no data in the recordset, but I just remembered that I abandoned that tactic before because I am also using the subform to input the allocation data. I haven't written that part of the code yet. I'm trying to fiox this before I attack that. I input the current data directly in the table so that I could work on the code to read the data.I do not understand how the code... -
I was using my "working" db, but I just put the same code for the else clause in the file I zipped and attached here. I tried .controls, .form.controls, and .form!controls, and I get the same error for all three as I mentioned above. Is it possible for you to zip what you've done and post here?
Also, my brainstorm of the morning as I awoke, but have not had a chance to look at yet is...should I consider hiding fsubAllocations...Leave a comment:
-
Chip,
I can't tell you how many times I've been there and done that in the past two weeks. I've even tried .forms!Controls all to no avail. It works above without the .form, so why the hang up here? And why is it jumping to the Else portion if the recordset is not empty?
I've probably put in about 20 hours just on this one little thing.
JimLeave a comment:
-
Chip,
I am. It's the exact same statement that is used about ten lines above at the beginning of the "Do While" segment and works there. That's what has been puzzling me for the last two weeks. Why does it work in one instance and not the other?
The subform itself is fsubAllocations , where as the subform control/container is "Monthly Allocation Subform".
Thanks,
JimLeave a comment:
-
Chip,
Thank you for your review and comments. I've tried various ways of what you suggested, all with futility. Here's what I just tried adding where you put the self statement...
Now I get the following error......Code:Else For Each ctl In Forms!frmPersonnel![Monthly Allocations Subform].Controls If ctl.ControlType = acTextBox Then ctl.Value = "" End If Next ctl
Leave a comment:
-
Unbound Text Boxes in Subform
I have a form (Form1) which contains basic Project data and a subform listing the personnel assigned to the Project as a continuous form. Selecting a person on that project and clicking on a command button will open a new form (Form2).
Form2 has two subforms. Both are embedded in the main form. (Subform2 is NOT embedded in subform1.) Subform1 displays records as a continuous form based on the Primary ID of the main form and lists...
No activity results to display
Leave a comment: