N nisha Registered User. Local time Today, 10:55 Joined Aug 18, 2009 Messages 22 Sep 29, 2009 #1 Hi, I have two list box controls in a form . I want to delete the items from listbox1 after moving those to listbox 2. any help on this??
Hi, I have two list box controls in a form . I want to delete the items from listbox1 after moving those to listbox 2. any help on this??
G Galaxiom Super Moderator Staff member Local time Tomorrow, 05:55 Joined Jan 20, 2009 Messages 12,832 Sep 29, 2009 #2 Me!listboxname.RowSource = "" If you only want to remove some entries you will need to read out and edit the rowsource. Otherwise use a query as the rowsource and either change that or change the records in the underlying tables. Here is some comprehensive stuff on Rowsource http://msdn.microsoft.com/en-us/library/55693axk(VS.80).aspx
Me!listboxname.RowSource = "" If you only want to remove some entries you will need to read out and edit the rowsource. Otherwise use a query as the rowsource and either change that or change the records in the underlying tables. Here is some comprehensive stuff on Rowsource http://msdn.microsoft.com/en-us/library/55693axk(VS.80).aspx