470,848 Members | 1,060 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,848 developers. It's quick & easy.

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


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.Open "tblClientProfilesReadmission", , adOpenDynamic, adLockOptimistic
With myRSReadmit
!CoMentalH = Me.CoMentalH

but I get the error message Me.CoMentalH = Null. The same error occurs whether items are selected or not in the primary combobox
May 13 '21 #1
0 4008

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Wayne Wengert | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.