468,484 Members | 1,578 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

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

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.Open "tblClientProfilesReadmission", , adOpenDynamic, adLockOptimistic
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
4 Weeks Ago #1
0 3402

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
reply views Thread by NPC403 | last post: by
2 posts views Thread by gieforce | last post: by
reply views Thread by theflame83 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.