View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Populate a Userform from an existing Record.

You could...
Use a ListBox on the form filled with the 1500 records.
Selecting a ListBox item would add that item to a Textbox.
User would edit the Textbox and press a button which
would add the corrected text back to the database.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Dooley007"
wrote in message
I am making a database that will contain about 1500 records when it is
completed. I have need to go back into certain Records and make
corrections to the data. I have been able to select the record (by
searching for the Last Name) I want to change but I would like to
re-populate a userform with the existing data and then make any
necessary revisions. Then I will add the revised record back into its
original place.

I can't seem to get the info back into a userform so that my program
will run and make the changes to approprate cells. Any help would be
greatley appreciated.

I hope this is clear enough and someone with more programming knowledge
will be able to help.