how to have data that is clicked on start a new record in subtable?

[Johnny0123]

hi,

I have a listbox that has file names in it. When a file is doubleclicked it displays in a textbox of a record in a subtable(which is in datasheet view).

MY Problem is if the user clicks the data again, it overrides the previous record. How to make it fill the next new record?

Thanks,

-John

 

[LaurieHamlin]

If I understand correctly, all you need to do is create a button that will take the user to a new record. They click it to go to a new record then enter the next set of data.

 

[Johnny0123]

well, i was trying to not make a button but do the same think as a button in the doubleclick function.