Split Forms: Just. Say. NO!

Hi. Would you mind posting a demo of your split form with the broken BeforeUpdate event, so I can learn from it? Thanks.
I will work on posting a scaled down version when I get back to the office. Getting around on the weekends can be a little tricky because the Carabinieri are out there in force.

In the meantime, here is Gina's code that I adapted.
 
Well this noob is using split forms with success, though I will admit there are things I can't seem to do, such as referring to a specific record # in the datasheet. There are probably other things I haven't run into.

I don't like how a split form datasheet will force your entire form window's dimensions to the max and there is no way to control it. If that is a problem you need to change to continuous form view or put your data in a subform instead.
 
Well this noob is using split forms with success, though I will admit there are things I can't seem to do, such as referring to a specific record # in the datasheet. There are probably other things I haven't run into.

I don't like how a split form datasheet will force your entire form window's dimensions to the max and there is no way to control it. If that is a problem you need to change to continuous form view or put your data in a subform instead.
Hi. I'm interested in understanding your comments a little better. Could you please elaborate on your points below?
  1. What do you mean by you can't refer to a record # in the datasheet?
  2. What do you mean by the datasheet will force the entire window's dimensions to the max?
Thanks!
 
it's a small niggle but the only thing I don't like about the shortcut menu is (Select All) scrolls (same in Excel). The number of times I start scrolling, find the value I want then realise I've not unticked the select all option - at least excel has a search box so you can limit the list.
 
Hi. I'm interested in understanding your comments a little better. Could you please elaborate on your points below?
  1. What do you mean by you can't refer to a record # in the datasheet?
  2. What do you mean by the datasheet will force the entire window's dimensions to the max?
Thanks!
1. I tried variations of Gina's code to return the record selector to the previously selected record after a requery of the datasheet with no success.
2. If you bind a split form datasheet to a query, the resulting window will be huge and it does not respond to setting the window height/width in VBA.
 
1. I tried variations of Gina's code to return the record selector to the previously selected record after a requery of the datasheet with no success.
2. If you bind a split form datasheet to a query, the resulting window will be huge and it does not respond to setting the window height/width in VBA.
Hi. Thanks for the clarification. You are not talking about the same code from Gina that @NauticalGent mentioned, correct? If so, can you please post a link to it, so I can take a look? I am not sure what you mean by binding the datasheet portion of a Split Form to a query. Did you mean you based the whole form to a query? I mean, the single view form and the datasheet portion of a Split Form both use the same Record Source property. They are not separate.
 
Hi. Thanks for the clarification. You are not talking about the same code from Gina that @NauticalGent mentioned, correct? If so, can you please post a link to it, so I can take a look? I am not sure what you mean by binding the datasheet portion of a Split Form to a query. Did you mean you based the whole form to a query? I mean, the single view form and the datasheet portion of a Split Form both use the same Record Source property. They are not separate.
Yes, that is what I mean. Sorry for the confusion.

The issue I had with the requery was here: https://www.access-programmers.co.u...y-underlying-form-but-retain-bookmark.309650/
 
Well DBG, while I was duplicating the issue, I discovered what the problem is. In the datasheet portion of the split form, you can hide fields. If you try to setfocus on the mainform to a field that is hidden on the data sheet, you run into a problem.
Mystery solved and it just reaffirms my belief that splitforms are just not worth it.

Not a bad days work!
 
Well DBG, while I was duplicating the issue, I discovered what the problem is. In the datasheet portion of the split form, you can hide fields. If you try to setfocus on the mainform to a field that is hidden on the data sheet, you run into a problem.
Mystery solved and it just reaffirms my belief that splitforms are just not worth it.

Not a bad days work!
Hi. Thanks for the update. Do you know if it's possible to modify the code to skip the hidden columns (or at least handle them more gracefully somehow)? Cheers!
 
Last edited:
Hi. Thanks for the update. Do you know if it's possible to modify the code to skip the hidden columns (or at least handle them more gracefully somehow)? Cheers!
Not for certain. If a hidden field is one you want to validate and the. Set focus on then the only work around I could think of would be to unhide the fields in question, finish up the before update code and then hide them again with an after update routine?

Even if that were possible, which I'm certain it is, that is a lot of work for something that can be achieved with less work.
 
Not for certain. If a hidden field is one you want to validate and the. Set focus on then the only work around I could think of would be to unhide the fields in question, finish up the before update code and then hide them again with an after update routine?

Even if that were possible, which I'm certain it is, that is a lot of work for something that can be achieved with less work.
Okay, sounds good. However, I have to let you know, I just tried Gina's code on a Split Form with a required hidden column, and I didn't have any problems with it. Her code worked fine for me. Cheers!
 
Not really. I'll post it tomorrow...its 0130 here and I need to get some sleep!
 
Ok here it is. I have figured out what is causing the issue and I'm sure you will see it much quicker than I did!

At any rate, the issue goes away once you do one of three things:
1. Change to form from split to single.
2. Unhide the ReferredBy field in the datasheet.
3. Remove the code in the OnCurrent event.
 

Attachments

Well thanks NG. 😏
I just opened your database on my tablet and had to use task manager to extricate myself from it.

One of the many advantages of the Emulated split form is that you can hide fields in the datasheet/continuous part of the form whilst still setting the focus to that field in the single record part of the form.
Basically the built in split form is OK until you want to change it in any significant way. At that point, it becomes almost impossible to work with.

NOTE the ESF can also be found here in sample databases https://www.access-programmers.co.uk/forums/threads/emulating-the-split-form.294421/
 
Last edited:
Well thanks NG. 😏
I just opened your database on my tablet and had to use task manager to extricate myself from it.

One of the many advantages of the Emulated split form is that you can hide fields in the datasheet/continuous part of the form whilst still setting the focus to that field in the single record part of the form.
Basically the built in split form is OK until you want to change it in any significant way. At that point, it becomes almost impossible to work with.

NOTE the ESF can also be found here in sample databases https://www.access-programmers.co.uk/forums/threads/emulating-the-split-form.294421/
In fact one of the biggest benefits I thought, was that you do not even need the fields.?
I first came upon them when working for Lloyds Bank and just wanted the datasheet portion for some easy selection of key fields and was disappointed when I found I could not do that.
 

Users who are viewing this thread

Back
Top Bottom