424,294 Members | 1,898 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,294 IT Pros & Developers. It's quick & easy.

For split form, how to I add a Text Box with label in form & control in datasheet?

P: 14
For a Split Form, how do I add a Text Box with the label in form above & the control in the datasheet below?
I can start over and use the wizard, but to edit an existing split form, to add a field from the field list, I drag and both label and control end up above the split or both below. MS Help says one goes one place and the other goes the other, but it doesn't seem to work. Any help would be appreciated

thx
cb
Apr 19 '11 #1

✓ answered by mshmyob

Chris you probably won't like this answer but here goes...

As you know split forms were introduced in AC2007. They are simply a form with a "special" type of subform that is always set to datasheet mode and moves the main form data to match the selected "subform" data.

As you may have noticed there are major limitations to the split form:

1. You have no control over the appearance of the subform
2. You cannot edit the subform (it doesn't even show in the form or in the object list)
3. The "Me" reference does not work in this type of subform and you must always fully reference any control in the subform or Access pops up an error.
4. Adding coding behind the subform is next to if not impossible.

To accomplish the exact same thing with no limitations you can just use a standard subform.

The only reason I can think why M$ even included splitforms was so a beginner developer wouldn't have to answer 3 or 4 questions in the standard subform wizard.

cheers,

Share this Question
Share on Google+
3 Replies


mshmyob
Expert 100+
P: 903
Chris you probably won't like this answer but here goes...

As you know split forms were introduced in AC2007. They are simply a form with a "special" type of subform that is always set to datasheet mode and moves the main form data to match the selected "subform" data.

As you may have noticed there are major limitations to the split form:

1. You have no control over the appearance of the subform
2. You cannot edit the subform (it doesn't even show in the form or in the object list)
3. The "Me" reference does not work in this type of subform and you must always fully reference any control in the subform or Access pops up an error.
4. Adding coding behind the subform is next to if not impossible.

To accomplish the exact same thing with no limitations you can just use a standard subform.

The only reason I can think why M$ even included splitforms was so a beginner developer wouldn't have to answer 3 or 4 questions in the standard subform wizard.

cheers,
Apr 20 '11 #2

P: 14
mshmyob
Thanks. Better to know the truth than to wallow in frustration. Seemed like quite a bit of erratic behavior but I am new to this so I always question myself first.
Apr 21 '11 #3

mshmyob
Expert 100+
P: 903
You're welcome. If you need help emulating the split form functionality with a standard subform just let us know.

cheers,
Apr 21 '11 #4

Post your reply

Sign in to post your reply or Sign up for a free account.