Input into Form adds extra blank row in Datasheet

Hello,

I can't figure out what I'm doing wrong. Please, help!

I designed a Form to input data. Now when I enter the data and open the
table (datasheet view) where the data goes into I see that an extra row has
been added, with Field 1 and Field 2 in blank. (The link fields are Report Nr
and Work Area.)

This is what appears:

Report Nr | Work Area | Field 1 | Field 2 |
1 | 2 | 10 | 23 |
1 | 2 | | |
1 | 2 | 57 | 1 |
1 | 2 | | |
1 | 5 | 15 | 45 |
1 | 5 | | |
2 | 3 | 11 | 4 |
2 | 3 | | |

And what should appear is this:

Report Nr | Work Area | Field 1 | Field 2 |
1 | 2 | 10 | 23 |
1 | 2 | 57 | 1 |
1 | 5 | 15 | 45 |
2 | 3 | 11 | 4 |


The Form has 3 Subforms. The second and third Subforms are linked to the
first Subform thru the Work Area field. The fist Subform is linked to the
Form thru the Report Nr field. The Form has fields from Table 1 and the 3
Subforms have fields from Table 2.

Form:
Report Nr (PK)
Field A1
Field A2

Subform 1:
Report Nr
Work Area
Field B1
....
Field B4

Subform 2:
Report Nr
Work Area
Field B5
....
Field B14

Subform 3:
Report Nr
Work Area
Field B15
....
Field B24


The tables are these:

Table 1:
Report Nr (PK)
Field A1
Field A2

Table 2:
Report Nr
Work Area
Field B1
Field B2
....
Field B23
Field B24


Please, please, please, Help!!!

--
igor

Hi Igor,

Yes, it is clear why you are having trouble. By using three subforms,
all accessing the same table, it will attempt to create new rows each time
you enter something in any of the subforms. That is, unless you specifically
requery each of the two other subforms whenever something has been saved in
one of them. Have you set the combination of Report Nr and Work Area as the
primary key in Table 2? I suspect not, otherwise it would have squawked at
you about duplicate records. Also, you should make liberal use, where
possible, of the required property of each field in the table for those
fields that must be entered. I also suspect if you look at the entire
contents of the "duplicate" rows, that you will see information in the one
row that was entered into the first subform. But not anything entered into
the second or third subform in that row. Likewise, you will see stuff
entered into the second or third subform in succeeding "duplicate" rows. If
none of that fits, let me know.

For a better design, I would suggest that instead of three subforms,
you use one subform that has a tab control on it, with three tabs. Each tab
will contain the appropriate parts from your original three subforms.

Hope this helps,

Clifford Bass

"Igorin" wrote:

Hello,

I can't figure out what I'm doing wrong. Please, help!

I designed a Form to input data. Now when I enter the data and open the
table (datasheet view) where the data goes into I see that an extra row has
been added, with Field 1 and Field 2 in blank. (The link fields are Report Nr
and Work Area.)

This is what appears:

Report Nr | Work Area | Field 1 | Field 2 |
1 | 2 | 10 | 23 |
1 | 2 | | |
1 | 2 | 57 | 1 |
1 | 2 | | |
1 | 5 | 15 | 45 |
1 | 5 | | |
2 | 3 | 11 | 4 |
2 | 3 | | |

And what should appear is this:

Report Nr | Work Area | Field 1 | Field 2 |
1 | 2 | 10 | 23 |
1 | 2 | 57 | 1 |
1 | 5 | 15 | 45 |
2 | 3 | 11 | 4 |


The Form has 3 Subforms. The second and third Subforms are linked to the
first Subform thru the Work Area field. The fist Subform is linked to the
Form thru the Report Nr field. The Form has fields from Table 1 and the 3
Subforms have fields from Table 2.

Form:
Report Nr (PK)
Field A1
Field A2

Subform 1:
Report Nr
Work Area
Field B1
...
Field B4

Subform 2:
Report Nr
Work Area
Field B5
...
Field B14

Subform 3:
Report Nr
Work Area
Field B15
...
Field B24


The tables are these:

Table 1:
Report Nr (PK)
Field A1
Field A2

Table 2:
Report Nr
Work Area
Field B1
Field B2
...
Field B23
Field B24


Please, please, please, Help!!!

--
igor

Hello, Clifford!

What you suggest makes sense and I suspect that it will solve my problem. I
will try it today and let you know if it works.

Thank you very much for the help!

--
igor


"Clifford Bass" wrote:

Hi Igor,

Yes, it is clear why you are having trouble. By using three subforms,
all accessing the same table, it will attempt to create new rows each time
you enter something in any of the subforms. That is, unless you specifically
requery each of the two other subforms whenever something has been saved in
one of them. Have you set the combination of Report Nr and Work Area as the
primary key in Table 2? I suspect not, otherwise it would have squawked at
you about duplicate records. Also, you should make liberal use, where
possible, of the required property of each field in the table for those
fields that must be entered. I also suspect if you look at the entire
contents of the "duplicate" rows, that you will see information in the one
row that was entered into the first subform. But not anything entered into
the second or third subform in that row. Likewise, you will see stuff
entered into the second or third subform in succeeding "duplicate" rows. If
none of that fits, let me know.

For a better design, I would suggest that instead of three subforms,
you use one subform that has a tab control on it, with three tabs. Each tab
will contain the appropriate parts from your original three subforms.

Hope this helps,

Clifford Bass

"Igorin" wrote:

Hello,

I can't figure out what I'm doing wrong. Please, help!

I designed a Form to input data. Now when I enter the data and open the
table (datasheet view) where the data goes into I see that an extra row has
been added, with Field 1 and Field 2 in blank. (The link fields are Report Nr
and Work Area.)

This is what appears:

Report Nr | Work Area | Field 1 | Field 2 |
1 | 2 | 10 | 23 |
1 | 2 | | |
1 | 2 | 57 | 1 |
1 | 2 | | |
1 | 5 | 15 | 45 |
1 | 5 | | |
2 | 3 | 11 | 4 |
2 | 3 | | |

And what should appear is this:

Report Nr | Work Area | Field 1 | Field 2 |
1 | 2 | 10 | 23 |
1 | 2 | 57 | 1 |
1 | 5 | 15 | 45 |
2 | 3 | 11 | 4 |


The Form has 3 Subforms. The second and third Subforms are linked to the
first Subform thru the Work Area field. The fist Subform is linked to the
Form thru the Report Nr field. The Form has fields from Table 1 and the 3
Subforms have fields from Table 2.

Form:
Report Nr (PK)
Field A1
Field A2

Subform 1:
Report Nr
Work Area
Field B1
...
Field B4

Subform 2:
Report Nr
Work Area
Field B5
...
Field B14

Subform 3:
Report Nr
Work Area
Field B15
...
Field B24


The tables are these:

Table 1:
Report Nr (PK)
Field A1
Field A2

Table 2:
Report Nr
Work Area
Field B1
Field B2
...
Field B23
Field B24


Please, please, please, Help!!!

--
igor

Clifford,

I've been trying to do this but I can't get it to work:

I've created the subform with all the information and I've created the tab
control in the subform. However I can't add the individual parts from the
subform to each tab, the parts appears to be on top of the tab control
instead of in the tab control itself.

Could you give me a hand, please? I've tried and tried but I can't figure it
out.

--
igor


"Clifford Bass" wrote:

Hi Igor,

Yes, it is clear why you are having trouble. By using three subforms,
all accessing the same table, it will attempt to create new rows each time
you enter something in any of the subforms. That is, unless you specifically
requery each of the two other subforms whenever something has been saved in
one of them. Have you set the combination of Report Nr and Work Area as the
primary key in Table 2? I suspect not, otherwise it would have squawked at
you about duplicate records. Also, you should make liberal use, where
possible, of the required property of each field in the table for those
fields that must be entered. I also suspect if you look at the entire
contents of the "duplicate" rows, that you will see information in the one
row that was entered into the first subform. But not anything entered into
the second or third subform in that row. Likewise, you will see stuff
entered into the second or third subform in succeeding "duplicate" rows. If
none of that fits, let me know.

For a better design, I would suggest that instead of three subforms,
you use one subform that has a tab control on it, with three tabs. Each tab
will contain the appropriate parts from your original three subforms.

Hope this helps,

Clifford Bass

"Igorin" wrote:

Hello,

I can't figure out what I'm doing wrong. Please, help!

I designed a Form to input data. Now when I enter the data and open the
table (datasheet view) where the data goes into I see that an extra row has
been added, with Field 1 and Field 2 in blank. (The link fields are Report Nr
and Work Area.)

This is what appears:

Report Nr | Work Area | Field 1 | Field 2 |
1 | 2 | 10 | 23 |
1 | 2 | | |
1 | 2 | 57 | 1 |
1 | 2 | | |
1 | 5 | 15 | 45 |
1 | 5 | | |
2 | 3 | 11 | 4 |
2 | 3 | | |

And what should appear is this:

Report Nr | Work Area | Field 1 | Field 2 |
1 | 2 | 10 | 23 |
1 | 2 | 57 | 1 |
1 | 5 | 15 | 45 |
2 | 3 | 11 | 4 |


The Form has 3 Subforms. The second and third Subforms are linked to the
first Subform thru the Work Area field. The fist Subform is linked to the
Form thru the Report Nr field. The Form has fields from Table 1 and the 3
Subforms have fields from Table 2.

Form:
Report Nr (PK)
Field A1
Field A2

Subform 1:
Report Nr
Work Area
Field B1
...
Field B4

Subform 2:
Report Nr
Work Area
Field B5
...
Field B14

Subform 3:
Report Nr
Work Area
Field B15
...
Field B24


The tables are these:

Table 1:
Report Nr (PK)
Field A1
Field A2

Table 2:
Report Nr
Work Area
Field B1
Field B2
...
Field B23
Field B24


Please, please, please, Help!!!

--
igor

Clifford, it's alright. I finally figured it out.

Thank you very much for your help!

--
igor


"Clifford Bass" wrote:

Hi Igor,

Yes, it is clear why you are having trouble. By using three subforms,
all accessing the same table, it will attempt to create new rows each time
you enter something in any of the subforms. That is, unless you specifically
requery each of the two other subforms whenever something has been saved in
one of them. Have you set the combination of Report Nr and Work Area as the
primary key in Table 2? I suspect not, otherwise it would have squawked at
you about duplicate records. Also, you should make liberal use, where
possible, of the required property of each field in the table for those
fields that must be entered. I also suspect if you look at the entire
contents of the "duplicate" rows, that you will see information in the one
row that was entered into the first subform. But not anything entered into
the second or third subform in that row. Likewise, you will see stuff
entered into the second or third subform in succeeding "duplicate" rows. If
none of that fits, let me know.

For a better design, I would suggest that instead of three subforms,
you use one subform that has a tab control on it, with three tabs. Each tab
will contain the appropriate parts from your original three subforms.

Hope this helps,

Clifford Bass

"Igorin" wrote:

Hello,

I can't figure out what I'm doing wrong. Please, help!

I designed a Form to input data. Now when I enter the data and open the
table (datasheet view) where the data goes into I see that an extra row has
been added, with Field 1 and Field 2 in blank. (The link fields are Report Nr
and Work Area.)

This is what appears:

Report Nr | Work Area | Field 1 | Field 2 |
1 | 2 | 10 | 23 |
1 | 2 | | |
1 | 2 | 57 | 1 |
1 | 2 | | |
1 | 5 | 15 | 45 |
1 | 5 | | |
2 | 3 | 11 | 4 |
2 | 3 | | |

And what should appear is this:

Report Nr | Work Area | Field 1 | Field 2 |
1 | 2 | 10 | 23 |
1 | 2 | 57 | 1 |
1 | 5 | 15 | 45 |
2 | 3 | 11 | 4 |


The Form has 3 Subforms. The second and third Subforms are linked to the
first Subform thru the Work Area field. The fist Subform is linked to the
Form thru the Report Nr field. The Form has fields from Table 1 and the 3
Subforms have fields from Table 2.

Form:
Report Nr (PK)
Field A1
Field A2

Subform 1:
Report Nr
Work Area
Field B1
...
Field B4

Subform 2:
Report Nr
Work Area
Field B5
...
Field B14

Subform 3:
Report Nr
Work Area
Field B15
...
Field B24


The tables are these:

Table 1:
Report Nr (PK)
Field A1
Field A2

Table 2:
Report Nr
Work Area
Field B1
Field B2
...
Field B23
Field B24


Please, please, please, Help!!!

--
igor

On Tue, 27 Jan 2009 08:36:01 -0800, Igorin
wrote:

Clifford,

I've been trying to do this but I can't get it to work:

I've created the subform with all the information and I've created the tab
control in the subform. However I can't add the individual parts from the
subform to each tab, the parts appears to be on top of the tab control
instead of in the tab control itself.

Could you give me a hand, please? I've tried and tried but I can't figure it
out.

Putting a control onto an existing tab page is a bit tricky. If you just copy
and paste it, it will go "in front" of the tab page, logically on the Form
itself.

Select the control you want to copy; type Ctrl-X to cut it to the clipboard.
Then select the small rectangle in the tab at the top of the tab page (the
page will darken) and type Ctrl-V to paste it onto the page. It will land in
the upper left corner (or as near as it can get) and will need to be
repositioned.
--

John W. Vinson [MVP]

Hi Igor,

Glad to hear it. I trust John's information helped. You are welcome!

Clifford Bass

"Igorin" wrote:

Clifford, it's alright. I finally figured it out.

Thank you very much for your help!

--
igor

Thanks, John!
--
igor


"John W. Vinson" wrote:

On Tue, 27 Jan 2009 08:36:01 -0800, Igorin
wrote:

Clifford,

I've been trying to do this but I can't get it to work:

I've created the subform with all the information and I've created the tab
control in the subform. However I can't add the individual parts from the
subform to each tab, the parts appears to be on top of the tab control
instead of in the tab control itself.

Could you give me a hand, please? I've tried and tried but I can't figure it
out.

Putting a control onto an existing tab page is a bit tricky. If you just copy
and paste it, it will go "in front" of the tab page, logically on the Form
itself.

Select the control you want to copy; type Ctrl-X to cut it to the clipboard.
Then select the small rectangle in the tab at the top of the tab page (the
page will darken) and type Ctrl-V to paste it onto the page. It will land in
the upper left corner (or as near as it can get) and will need to be
repositioned.
--

John W. Vinson [MVP]