Recalling data to userform after searching dadabase

Hi I have UserForm1 that writes 30+ items (TextBoxes, CheckBoxes, OptionButtons, and 2 ComboBoxes) to a batabase sheet. Each time the form opens UserForm1 generates a sequential Invoice number based on the last time data was writen to the Database. This sequential number is places in column "A" on the row with the data. I want to be able to open another Form "UserForm2" with the exact same group of TextBoxes and checkBoxes. In the TextBox on UserForm2 that from UserForm1 held the automaticaly generated sequential number I want to input any of the previous generated numbers which will then search for the row and then bring that row data back into the userform. after it is edited click an update buton which writes the data back to the Database sheet in the same row that the original data was held or delete the old row and write a new row so there is not duplicate entry

Her is sample of my code that send the data to the database sheet, I hope this questing is not to long. If it helps the TextBox that holds the sequential number is TextBox53.Value

Please Login or Register  to view this content.

Hi StartingOut

Roy has a good example of searching code with a userform
http://www.excel-it.com/vba_examples.htm