Hi All,
I have 15 forms set up to enter data in Excel which then gets stored
in a hidden worksheet in the workbook.

Right now it is set up so that the user can scroll through all 15
forms, enter the data, and then they are prompted to save to the
database, which copies all the data over and erases the forms.

I think it will be useful to allow them to re-load the data they've
already entered, in case they need to make changes. So I'm imagining
some kind of drop box or something that will display all the IDs
associated with the information they've entered, and then they would
select one and the data would load, then whatever changes they made
would be recopied to that row.

I'm hoping this is relatively simple to do.... what is the best way to
approach this?

Thanks in advance.

I think that if it was my project that I would try to put my quality control
up front by managing the input rather than correcting the output.



"lcoreilly" wrote in message
...
Hi All,
I have 15 forms set up to enter data in Excel which then gets stored
in a hidden worksheet in the workbook.

Right now it is set up so that the user can scroll through all 15
forms, enter the data, and then they are prompted to save to the
database, which copies all the data over and erases the forms.

I think it will be useful to allow them to re-load the data they've
already entered, in case they need to make changes. So I'm imagining
some kind of drop box or something that will display all the IDs
associated with the information they've entered, and then they would
select one and the data would load, then whatever changes they made
would be recopied to that row.

I'm hoping this is relatively simple to do.... what is the best way to
approach this?

Thanks in advance.