Copy & Paste combobox value between userforms

Hi All,

Heres the scenario...

form1 has a combobox (partnumber) with a vlookup function... If the partnumber has zero quantity then user then opens form2 via command button to add quantity to that partnumber.

My question is: What is the code for copying the combobox1 value from form1 over to combobox2 in form 2?

I can attach the file if needed?

Thanks in advance

Vaughan

If you attach the file it will make it easier to provide the solution.

BSB

Hi again,

Unable to attach file.. Manage uploads page appears and hangs when trying to upload???

Have uploaded here if needed.. http://s000.tinyupload.com/index.php...22988317295392


Thanks

You will see when you open the file that there are 2 command buttons on the frmInventory. 'Add to Stock' and 'Remove from Stock' ... both these trigger new forms to open.. frmAdd & frmRemove

If the user has taken the time to already search the inventory I would like to bring the value of cboPartNumber from frmInventory over the which ever form opens.. Either frmAdd or frmRemove. The combobox's are called cboPartNumberAdd and cboPartNumberRemove (I think)

Thanks again

I think this is what you're after. If not, let me know and I'll have another look.

I've added a line of code to Module1 that sets the contents of the item number box to a variable and this variable is updated whenever the item number box is changed.
Then the initialize event of each of the add & remove userforms applies that variable to the relevant combobox.

Hope that helps.

BSB

Many Many Many Thanks BadlySpelledBuoy !!!

SOLVED !!!

Cheers,
Vaughan