Multiple userForms maintaining data integrity

[Daragh_K]

Hi,
Hoping someone could advise me here.

I have an execl spreadsheet preloaded with data on multiple sheets.
I am currently using multiple userForms to display the data.
On userForm1 i have two listboxes.
I move values from listbox 1 to listbox 2 using a button called 'Select_cmd'.
Prior to the selected record value moving to listbox 2 a second userForm pops up where I populate
other fields on that record using radio buttons.

How do i ensure that i am updating the correct record using the second userForm?

Does anyone have advice on how to use multiple forms and maintain data integrity?

Thanks

 

[mole999]

sounds like a need for a unique record key, that can then be referenced against

 

[royUK]

One userform with a MultiPage control would be easier to manage

 

[Daragh_K]

Thanks royUK,
I'm already using multipage control for other functionalities.
I need a 'pop up' that allows a user to simply select radio buttons, which in turn populate the same record selected on the list available on the first form.

If you think of anything, please let me know

 

[Daragh_K]

Yes ideally I would do it in a database, but unfortunately I'm restricted to excel.
I may assign a unique id for each record and query each time a selection is made on the list of form 1.

I thought there might be a way to access the selected record via form1 and populate the cells for that row.
It far easier to do this type of thing in the Object oriented world

Thanks for your help

 

[Norie]

Are the multiple forms essentially the same, the only difference being the sheet they are used with/for?

 

[Daragh_K]

Are the multiple forms essentially the same, the only difference being the sheet they are used with/for?

Form one shows two listboxes, "Available" and "Selected". The "Available" listbox is populated from worksheet("Test") a range of A2:A500.
On selecting the value in 'Available' list box and clicking a cmdbutton named 'select', form2 pops up with several frames. Each frame has radio buttons asking what level of detail is required for the selected record.

On selecting the values on form2 I want to populate the remaining cells in that particular row, i.e. B2:P2

To put it another way:
1) I am looking to grab a record (row) in form one by selecting from a listbox and clicking a button,
2) I want to be able to enter/edit the cell values in that 'grabbed' row and save back to the same worksheet via a different 'popup' form

I hope that makes sense.

Thanks for your response

 

[Norie]

You could store the row you've grabbed the record from in a hidden textbox and use that when you want to write back the edited data.

If you are working with more than one form each one could have a similar textbox and you would populate it as you moved between the forms.