473,888 Members | 1,551 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access 2007: Split Forms with Subforms

378 Recognized Expert Contributor
Hello all! This is my first posting here, although I've been lurking here for months and getting lots of help & tips from the past posts here.

I'm in the process of updating our company's Access 2003 database to 2007, and while we're finding some of the new perks to be neat, I'm having a problem getting some of them to behave as we've envisioned. For starters, we're using the new Split Form feature. When the split form datasheet shows up at the bottom of the form, it's enabled to expand linked data from another subform/subdatasheet that's on the main form (most of our forms have a tab control with multiple tabs, each usually containing list boxes or subforms).

My question is:
a) is it possible to enable/disable that expansion option alltogether, only showing the data relevant to the main form, and

b) in the case when we want to use it, and we have multiple subforms on a main form, how do we select -which- subform is shown on the split form datasheet? It appears to only show one linked datasheet, and it's rarely the one we would want.

Thanks for your time guys, hope this was stated as clearly as possible.

Nov 12 '07 #1
10 26063
378 Recognized Expert Contributor
I now also have a totally separate problem that I need someone to verify if it's a bug or not with Split Forms.

On our forms, we have a combo box at the top that is used for jumping to record numbers (This list is filtered by a variety of choices, and the filter is applied to the form filter). By navigating records this way, all the On Current events work properly, and all the form data displays correctly.

But, if I navigate to a different record using the datasheet shown with the Split Form view, the data remains visually accurate on the form fields, but any calculations being used with the On Current events are using old data from prior records. I've tried adding in extra object requeries, and it helps in some instances, but I dont want to have to do an extra requery on the whole form basically to get the events working properly. =/ It's very frustrating, considering the correct data is visually in all the fields. Anyone else had any problems with this? Is everyone avoiding 2007 like the plague? ;)

I've looked on bug lists (allen brownes, microsofts) and havent seen this listed anywhere.

Thanks for your time,

Nov 13 '07 #2
378 Recognized Expert Contributor
Well it's been a few days since I've posted this, and nobody has replied, which I somewhat expected.

I've done some further testing with these problems, specifically the one in the 2nd part of my post, and thought I'd share my findings for anyone else who tries to use split forms in Access 2007. Hopefully you'll avoid the headaches I've had, or be able to identify the problem better than I have by seeing the issues presented here. I'd like for someone with Access 2007 to do some testing on their own to verify some of these bugs I'm finding. (Or even better, prove me wrong and guide me possibly to where I've gone astray)

First off, I believe the split form feature to be truly bugged. If your form is set to have a split, then the following bugs happen when you change records via clicking on the datasheet, OR when you use the form's Navigation Buttons.
Note: the record selector works normally if the Split Form feature is turned back off. If it's on, it inherits the problems that the split form datasheet has.

The following do NOT work during the Form-Current event, or events that have to do with a record # changing. (Form Load event seems to function, thankfully)

-Declared variables at the module level show up empty
-Combo Box data shows as null
-Toggle button on/off status needs an additional requery
-Toggle button captions need to be cleared first before applying a new value
-Label captions cannot be changed at all
-Unbound text fields need to be requeried, clicked on, or focus set, to display newly applied values

That's what I've found -so far-. All the issues are with unbound data or controls.
Now, I've managed a workaround for the variables and combo box data not working (which was my biggest issue). Luckily, in my case, these are all set on form load, and will not change while the same user is logged into the database. I had to make a label for each variable and set it's caption to whatever property I needed to preserve during the Load event, and then use those caption values in the Current events. It's a completely lame work-around, but so far the only way I've been able to get this database upgraded and working as it had before, using the new split form feature.

Also, another small bug of a different sort, is with Subform/Subreport controls. First off, if you have a subform control using a datasheet, your split form datasheet will be expandable to display this subdata beneath every row. It's a neat feature, allowing you to further filter on this subdata. But, if the subform control is using an actual form, the filtering is bugged and you'll get a sql error when trying to filter. My workaround for this, is to link a query to the subform control. By using a query only, the Split Form datasheet will expand, and easily allow you to filter without any problems.

My original problem that I posted about, however, still exists. If you have multiple subforms, there's no way that I've found to select WHICH of those expand in the split form datasheet.
Nov 16 '07 #3
1 New Member
I can confirm the issue with the labels not updating when changing records on the datasheet portion of the split view. This doesn't seem to be an issue when changing records using the navigation buttons. Have you found a solution to this? I am looking to visually alert my users of conditionally required data using the label. Turns out I can change the properties of the text boxes, but it's not as visually appealing. I'm going to try creating two labels and see if I can change visibility properties as forecolor doesn't work.
Jan 11 '08 #4
2 New Member
I have had similar problems with controls not updating when modified from a split formís Current event. I have found that changing the reference from, for example, lblTest or Me.lblTest to Forms!MyForm.lb lTest fixes the problem.
May 16 '08 #5
378 Recognized Expert Contributor
I have had similar problems with controls not updating when modified from a split formís Current event. I have found that changing the reference from, for example, lblTest or Me.lblTest to Forms!MyForm.lb lTest fixes the problem.
Thanks for taking the time to report this. Hopefully they'll fix all the bugs with the split forms in the future.. and give us designers a bit more control over the options.
May 16 '08 #6
2 New Member
Glad to help. I have found that the Me object in the Current event seems to refer to the datasheet half of the split form when it fires as a result of action taken in the datasheet half. Thus, if you then change some object, it changes the object in the datasheet half. Sometimes this leads to an automatic, corresponding change to the object on the form half, but not always.
May 16 '08 #7
1 New Member
Thank you orzeszek! That did the trick! Like Megalog, this was driving me nuts. I stepped through the code with the debugger and saw that the form object property changes I specified SHOULD have been firing -- but they didn't. Using the Forms!formname. object format fixed the problem. Clearly another Access 2007 bug, but the workaround did the job. Many thanks for the post.
Nov 4 '08 #8
cosm ic
1 New Member
Saved me a lot of time...
Sep 13 '09 #9
1 New Member
orzeszek,I only signed up to this forum to thank you for your tip. you are as star:-)
Sep 9 '10 #10

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

Similar topics

by: Ira Solomon | last post by:
Hi: Any quick opinions on Access 2007? Has anyone got this to coexist with Access 2003? Thanks Ira
by: Jasperuk | last post by:
Ok a real and i mean real complete novice to most things in access so please be patient i know very little about scripts and code. Trying to recreate a database at home based on practice during lunch at work. What i have is a database at work (Access 2003) which using a form with 2 list boxes on it, the first box gets its data from query1 about the product code and the second list box recovers the description from the same query1 based on...
by: ARC | last post by:
Hello, I like the split forms in access 2007, because you can still do the header, and any tool buttons, yet have the datasheet look without the need for 2 forms (main form / subform). However, if you add a button for "New Record", and try to set focus to the first field, it will set the focus to the top detail of the split form (even if you have this hidden with the splitter bar). Does anyone know how to get the focus to go to the...
by: ARC | last post by:
I posted this before, but no response. Hopefully the MVP folks will know the answer. I'm not sure how other's are using the new split form, but what I like about it is I can design the header part of the form with buttons, graphics, etc., then use the lower half as a datasheet. I move the splitter bar to completely hide the detail of the record, and only show the datasheet. This is nice, because I don't have to have a main form for the...
by: Shaun | last post by:
Hi all I have converted an accress XP data file to access 2007. The problem I now have is I cant add any data to the subforms. I have enabled all the allow options but still no go! Please help this is quite urgent. My Email address is shaunfish@gmail.com Ta Shaun Fisher
by: Wayne | last post by:
This is probably simple but: when using tabbed forms in A2007, is there a simple way to prevent the user from right-clicking on a form tab and choosing "Design View" other than disabling default shortcut menus?
by: avtuvy | last post by:
My Access 2007 access application includes a split form, The user updates or enters data to the top part of the form (text boxes) and than click a button to save the data. with thedefault settings of the form the data ism saved if the user exits the form and I need to change prevent that how can I do that?. With I wrote a similar app with Access 2003 and did all the work with VBA and it worked well but it did not have the split form feature...
by: stevenblanc | last post by:
I've been hunting for a while. Since they've removed the show in taskbar option after 2003 I figure the quick way is out, but, surely there is still a VBA method of getting it done. I've done searches on a few forums, asked some experts, and browsed microsofts database. Anyone here have any ideas?
by: Nej Sanerkin | last post by:
In Access 2007 I have encountered instances where Me.Filter = "... " fails to operate for a split form. Using a reference set to the form object e.g. frmObj.Filter = "...." also fails to operate. (In both these cases .Filter = " ... " is followed by .FilterOn = True. and in both cases a debug statement shows that the Filter and FilterOn have been updated as entered. However, using Forms!!.form.Filter = ".." works. I am already using...
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, weíll explore What is ONU, What Is Router, ONU & Routerís main usage, and What is the difference between ONU and Router. Letís take a closer look ! Part I. Meaning of...
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Duprť who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.