Create a split form

A split form is a new feature in Microsoft Office Access 2007 that gives you two views of your data at the same time — a Form view and a Datasheet view. The two views are connected to the same data source and are synchronized with each other at all times. Selecting a field in one part of the form selects the same field in the other part of the form. You can add, edit, or delete data from either part (provided the record source is updateable and you have not configured the form to prevent these actions).

Sponsored Links:

Related Topics

Split form on append query
I have been browsing this forum very often lately and I have learn a lot. could I create a split form from it? If I can,

The form will be used to enter data or paste multiple rows of data into the split form.


Split Forms
I’m new to both the Navigation Forms & Split Forms in Access 2010, but I can see that there is a lot to be gained from their use. What I could do with is some advice as to whether a split form can run in a navigation form? From my experience when I linked a split form into a navigation form it rendered as a single data entry form, however it still continued to work properly as a split form when called from the navigation pane.


Split Form Orientation...Coding?
I am redesigning forms to have a more compact and organized look. Currently, the split form view is used on all the main forms. Instead of the Datasheet portion of the split form in a separate pane, I'd like to put it on a tab in the pages control I've added to the form. There are only four options for the split form orientation property from the property sheet. I was wondering if I could use a little coding to put the split form orientation on a tab in the form itself


Split Form Orientation...Coding?
I am redesigning forms to have a more compact and organized look. Currently, the split form view is used on all the main forms. Instead of the Datasheet portion of the split form in a separate pane, I'd like to put it on a tab in the pages control I've added to the form.

There are only four options for the split form orientation property from the property sheet. I waswondering if I could use a little coding to put the split form orientation on a tab in the form itself?


Demo: Display a form and its datasheet simultaneously
When you work with forms in Access 2007, a split form view can be very useful. You simultaneously get two views of the form that are connected to the same data source. This demo shows you how to create a split form view, where you can use the datasheet part of the form to quickly locate a record and the form portion to view or change the record. You will also learn how to enhance and customize a split form view to suit your needs.


Split Form Input Box
Access 2010 offer many options to setup Form and its control in way you want. Many a times while creating form, we need to split a form control vertically or horizontally. You can for instance split a form control to let user enter his middle or surname.


Create forms for a new Access 2007 database
Learn how to create forms. Forms provide a window into your data, make your database look polished and professional, and help you enter data more accurately.
After completing this course you will be able to:
1)Use the Form tool to create a simple form.
2)Use the Split Form tool to create a split form — a form that lets you 3)work with single records and large amounts of data.
4)Use the Form Wizard to create a form.
5)Use Layout view to change a form.
6)Use Design view to change a form.


Split Forms
I am attempting to design a split form where I would like to filter the split form to show only show those records of a particular member chosen by a combo control on the parent form


Manually built split form
Since the split forms can't be used on a navigation form I am trying to manually build a split form and the appearance is great, but I cannot find how to link the subform to the main form for record navigation


unbound text box filter by form on Split Form
I have a split form, with several unbound text boxes, which I would normally use as a filter by form type function. the query has criteria bound to these text boxes.

My problem is that I cannot seem to get the mouse to focus on the unbound text boxes on this split form. when I click in the unbound filter by form text box, the focus immediately moves to the first text box that is bound to data on the form.

Then I will try recreating my split form in a different way. if it is a problem, If perhaps a split form cannot have any unbound data entry controls on it, then I could create a form with the search criteria on, and keep the forms separate. If I was to do this, though I would like to 'dock' this form at the top of the window, and then have the split form 'dock' underneath, as if there was an application level window splitter control. Another option might be to put the filter by form text boxes in the ribbon, and I have added some stuff here, but I am unsure how I might refer to the control in a query criteria.


Split Database Issue
I have a split database. This has a "multiple items" form (acting as a record search form called frmSearch) where they are able to click on the row and it will open up the detailof the record on a different form (frmLostItemEntry).

Now, this works perfectly from my home computer both before and after the split. Once I split it on my company's network this is what happens:

When you click on the row in frmSearch, the detail from shows up blank for records added after the split. If the record was added BEFORE the split the detail shows up correctly.

Here is the code that is in the OnClick event of the row in frmSearch


Modifying a split database
So a while back I created a database which I use to keep track of my companies large list of products. It is very simple only 3 tables, 1 query and 1 form. After running into a problem with copying and pasting updates on each computer in the office I decided to split the database on a network drive.

This worked for a bit, however I had to add new fields and modify the form, which corrupted the file. Luckily I had a backup before the split.

How do you modify a splitdatabase without corrupting the files or using a non-split copy?


making a table from a filtered split form
I have a split form that does exactly what I want, easily filtering data for the user. I also know how to create a map from a table of data using MapPoint. What I do not know how to do is to get the filtered data into a table, so that the mapping sequence can work.

Right now, the mapping is based on a table with 5 data points in it. All 5 of those data points are found on the split form


Split Form Issues
I'm having problems with my Split Form. I have certain code in the On Current event of my form, and when selecting different records with the record selectors on the bottom of the form, the code executes perfectly (hiding controls, etc.).

However, when I try to select different records with the Split Form datasheet record selectors, the same On Current code doesn't execute.Is there a way to work around this? It seems like the Split Form doesn't adhere to the On Current event.


Split Form Issues
I'm having problems with my Split Form. I have certain code in the On Current event of my form, and when selecting different records with the record selectors on the bottom of the form, all the code executes perfectly (hiding controls, etc.). However, when I try to select different records with the Split Form datasheet record selectors, the same On Current code doesn't execute. Is there a way to work around this? It seems like the Split Form doesn't adhere to the On Current event.


For split form, adding a Text Box with label in form & control in datasheet?
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.


Splitting a database
I have recently split my database using Access 2007 which has worked fine, but still feel unsure about how it works from here and can't seem to find any information on what happens next.

All the literature told me that when I split the database there would be tables in the BE and everything else in the FE but the tables are still showing in the FE with the link icon at the side, is this a new feature of 07 or am I mis-understanding.

* Do I keep the split FE copy as my copy (which is in the shared drive) or do I have this one or a copy in my local drive as well?
* When I make changes to the tables/forms etc is it just a case of sending the updated FE version to my colleagues?
* Is it possible to create a switchboard after the split or would I need to go back to my back-up copy to do this? (Have I split too early)
* What changes or additions can be made once a database has been split are you limited to what you can do


Refresh button on form that views as split form
I have a form that views as a split form, with the datasheet view on the bottom of the form. In the top section I have txt boxes created in order to use as an unbound form to enter data into, which my query then reads from and returns the subset of data that I want, this is displayed in the bottom of this form in the datasheet view.

so this form has the record source of my query. this is good and works fine. here is the problem.

when I use the default refresh button at the top of access in the "quick access toolbar" it works great, and it runs the query and displays the results in the bottom of my split form in datasheet view.

so I created a button on my split form "refresh" from the create button in design view, and it doesn't work at all. I then did some fiddling around with some macros, butto no avail.


Expansion box
Have a split form (Test Cell) based off a Query, I have inserted a form sub form (Priority) into my split form. On the data sheet portion of the split form there is an expansion box next to each record. If clicked on it displays the sub-form (Priority) data.

1 question Is there a way to hide this expansion box from display view.

2question is there a way to have this expansion box point to a different data source other then the sub form data.


Split form refresh
I have a split form and a button that updates another table. After it updates, it deletes the record. Is there a way to "refresh" the split form so it doesn't have the #DELETED# in the record?

Manually closing and reopening it works,