![]() |
Select from List Box
Have a list of names & Phone# in list box on Form1, want a macro to copy
selected names and paste to a table. Table is a subform in Form1(no relationship). All field names and format are similar) I have the form is 'Form1' the list box is SelectNames the table is ListOfNames(subform name is fsubListOfNames) Macro -- (On Dbl Click) GoToControl -- fsubListOfNames GoToRecord -- New SetValue -- Item -- [Forms]![Form1]![fsubListOfNames] Expression -- [Forms]![Form1]![SelectNames] I step through the macro, and ok until SetValue, then error message. Please help. |
All times are GMT +1. The time now is 06:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com