Form & Subform Inquiry

[arao]

I've set up a form to retrieve information from one table using a combo box,
whilst a subform writes to a second table
(The user selects an id using the main form, and this is added to the second
table along with information entered in the subform)

However, when I make a new entry in the form (i.e I select a new id, and
enter in subform info) a blank row is added to the second table. What could
be causing the blank row?

 

[Ken Snell \(MVP\)]

Is the blank row in addition to the new row of data that you entered into
the subform? Or is the blank row the only row that is being entered into the
second table, regardless of what you enter into the subform?

 

[arao]

Thanks for the help, Ken.

The blank row is being entered along with the data entered by my subform.
So when I go to the table recieving the information, I will have all the
correct data, except every five rows (I usually enter 5 pieces of data in
the subform, before clicking on a new entry in the main form) I will have a
blank that I then delete manually.

 

[Ken Snell \(MVP\)]

Show us your code that the form is using. Somewhere in that code, most
likely, you're causing the blank row to be saved to the table. We'll need to
see what you're doing so that we can help.

 

[arao]

Hi Ken,

I have been trying to get the source code, but cant seem to find it. How can
I enable and then view the vb code for the form? (I will then paste it on
this board)

Thanks again!

 

[Ken Snell \(MVP\)]

Open the form in Design view. On the toolbar, you'll see an icon that looks
like a square of connecting pipes (the "Code" button). Click that and you'll
go to the Visual Basic Editor, where your form's code will be shown.

Sorry for the delay for my reply; work has kept me busy this week.
--

Ken Snell
<MS ACCESS MVP>