Hi.
I am using Access 2010,
I have a table like below.
In a form, I have a combo box linked with the NAME field and have a buttonm, COPY next to it.
ID NAME NUMBER
1 BACH 1-1212
2 MOZART 2-2323
3 BEETHOVEN 3-4343
4 VIVALDI 4-5656
I would like to make the COPY button functioning copy the NUMBER when I choose a NAME from the combo box. I will paste the number somewhere else as clipboard.
Of course the NAME and the NUMBER should be the same record.
I couldn't find any COPY command in macro but does not matter VB command.
Thanks~