Hello,
I need help i have table and user form.
When i fill user form like this:
1.png
And press "Add record" i wanna get all data in my table like this:
result.png
Hello,
I need help i have table and user form.
When i fill user form like this:
1.png
And press "Add record" i wanna get all data in my table like this:
result.png
Try this.
Please Login or Register to view this content.
If posting code please use code tags, see here.
Thanks.
i get this...
2.png
Last edited by Bennasy23; 05-13-2020 at 09:27 AM.
do not transpose the array.
one set of option buttons are in conflict with the next row
Oops, that's my fault - I had the rows/columns for the array the wrong way round in the original code and added the transpose for testing
I then changed the code so the rows/columns were the right way round but forgot to remove the transpose.
Change this,
to this.Please Login or Register to view this content.
Please Login or Register to view this content.
Thank you for help.
One more question.
Now i should fill all text boxes, if you wanna add record.
It is possible make that i can fill sometimes just 1 or 6 or 5 or 2 text boxes ?
And maybe you can say what i need change if i wanna add more text boxes, and in table insert one more column?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks