The problem is when I click the Test button in the example the series does not refresh.
In design mode the data appears correctly and when the form is opened. Here’s what worked: Clear the Rowsource Property in the property window, make it blank Assign it in code in the Userform_initialize event (for example me.listbox1.rowsource = “nm Test”), so it is assigned at RUNTIME.However, if I increase the size of the named range any new data does not appear in the list, and I cannot seem to force a refresh of the list. Then after adding items RE-assign the rowsource again(for example me.listbox1.rowsource = “nm Test”) Let me know if you have any problems Bill Buker VBA Developer id="ctl00_m_m_i_ctl00_gr_ctl01_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="1964941" / Hi Nigel, Just gave a quick test and all worked here.Microsoft was "deeply sorry for the unintended offensive and hurtful tweets from Tay", and would only "look to bring Tay back only when we are confident we can better anticipate malicious intent that conflicts with our principles and values".To learn more about the City Navigator map series and compatibility with the Garmin Street Pilot range click here or scroll down to this page to the 'Garmin Street Pilot City Navigator NT Maps' section.I wonder whether the problem lies in the fact that I am adding/changing records within the list boxes Click event??
Regards Nigel" id="ctl00_m_m_i_ctl00_gr_ctl03_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="1965513" / Hi Bill Many thanks for the quick response, unfortunately I'm having no joy with this in my project.Also, if you are using 2 dataset instances (1 on each form) the dataset on teh original form needs to be refilled.The form's startup has | nothing special that I didn't already try for refreshing it.NET that allow you to easily create websites for working with the CRUD operations of an entire data model that exists as either a Data Context (such as LINQ to SQL) or an Object Context (such as LINQ to Entities). NET provides several server controls that build on top of the features of Microsoft ADO. These controls simplify the development of data-driven websites.They make it easier to build webpages that access, display, manipulate, and save data. You use these controls to configure access to data that you intend to use on a webpage.Using these controls can provide development efficiency when you are building business applications that rely heavily on data. A data source can be a relational database, data stored inside of in-memory objects (such as a Data Set or an Entity Data Model), XML-based data, or data you retrieve via Microsoft Language-Integrated Query (LINQ).