Subform problem

[radink]

I have a subform with lines for each task.

Ill fill it out and then hit the new record button (in the main form). When I click to go back to the previous record, a new line has been created at the top of the subform.

Is this a known problem? I made the subform pretty straight forward, so I'm not sure why it's doing this.

 

[lightray]

perhaps you could post an image so we can get a better idea about your problem

 

[radink]

Sure thing!

Here is the image:

The top part is what it should look like.

The bottom part is how it looks after a create a new record, and then go back to this one. You see that empty row gets inserted. This is really frustrating me. Any help would be greatly appreciated!

 

[ansentry]

I have just answered you in another thread.

How many time do you want to ask the same or similar question?

Any way to answer this question.

What is the Control source for the combo, I would suggest that you do not have one. When you close the form there is nothing in the data source so when the form opens again it will be empty - it is like entering data in an unbound text box, close the form and it empties.

 

[radink]

Ansentry,

They are 2 different problems if you read the full thread. One was about populating boxes from another and the other problem was blank lines being created.

 

[lightray]

Here is the image:

The top part is what it should look like.

The bottom part is how it looks after a create a new record, and then go back to this one. You see that empty row gets inserted. This is really frustrating me. Any help would be greatly appreciated!

Sorry, but unable to gather much from the images. The blank line seems to contain a lookup field, what happens when you click on the arrow?

 

[radink]

Thanks for replying. I fixed it already. I had it all setup wrong.

Thanks

 

[lightray]

Thanks for replying. I fixed it already. I had it all setup wrong.

Thanks

Great! What was wrong? How did you fix it?

 

[radink]

I didn't have a separate table for the subform. I had all the data in one table. Once I fixed this, the problem went away.

 

[lightray]

I didn't have a separate table for the subform. I had all the data in one table. Once I fixed this, the problem went away.

Thanks for posting back.

 

[ansentry]

Did you also get this one to work?

http://www.access-programmers.co.uk/forums/showthread.php?t=119893

 

[radink]

Ansentry,

I did. From all of the examples I had, none of them stated the need to change the amount of columns in the initial combobox. I though that column(3) was the column in the actual table, and not in the combobox.

Thanks for your help!