Copying selected combobox items from one table to another using VBA - access

[McKechnie]

G-Day,

I'm having trouble with VBA for copying the selected items from one combobox in one table to another equivalent combobox in another table using VBA. All the rest of the data copies over fine. I'm using simple VBA code to transfer the info between tables (e.g.,

myRSReadmit.Ope n "tblClientProfi lesReadmission" , , adOpenDynamic, adLockOptimisti c
With myRSReadmit
.AddNew
!CoMentalH = Me.CoMentalH
...
...
.Update

but I get the error message Me.CoMentalH = Null. The same error occurs whether items are selected or not in the primary combobox
Duncan