Morning folks. Another day, another learning lesson, trying to do something i have no idea about.
First off, i'm not looking for an exact solution, just what i should be looking to do and something to get me started.
I have a userform in Excel that submits data to a spreadsheet and an Access Database, this is up and running perfectly and submits 8 different fields of user inputted information. What i want to do is add a button that goes to a different userform with identical fields. But instead of submitting data to a DB i want to put some buttons in (forward and backwards) that allows the user to scroll through the different records saved in the database to review them.
The data would be shown in the correct fields which are identical to the other userform, so i'm thinking it may involve just swapping some of the code around to retrieve rather than submit.
Is this possible? and if so, whats a good start point for me (note, the other form has been created and buttons places in but are inactive)
If i need to be more specific, please let me know!
Many Thanks
First off, i'm not looking for an exact solution, just what i should be looking to do and something to get me started.
I have a userform in Excel that submits data to a spreadsheet and an Access Database, this is up and running perfectly and submits 8 different fields of user inputted information. What i want to do is add a button that goes to a different userform with identical fields. But instead of submitting data to a DB i want to put some buttons in (forward and backwards) that allows the user to scroll through the different records saved in the database to review them.
The data would be shown in the correct fields which are identical to the other userform, so i'm thinking it may involve just swapping some of the code around to retrieve rather than submit.
Is this possible? and if so, whats a good start point for me (note, the other form has been created and buttons places in but are inactive)
If i need to be more specific, please let me know!
Many Thanks
