Help with Edit/Search and Exit options on a Userform

[JNEWMAN]

Hi Forum
I have been messing around with a form design to input steps of a process flow, the data is loading successfully when input and then selecting Add on the userform and feeds to the correct DATA worksheet. I am trying to link a Search/Edit button and an Exit but going round in circles with it.

On opening the worksheet it shows 8 colours which represent the process steps 1 to 8, using the LOAD option above these colours opens the userform which does work ok but struggling to set up a link to the Edit, Search and Exit buttons. Excuse the scripting mess as I was trying different things.

Hope it makes sense, any help greatly appreciated.

Thanks
J.

[mjr veverka]

Scottish saving in words ... : )

Ok, after pressing the "Load" button, the "Process" form will be displayed

1. Should any default values be loaded into the text boxes or should they be empty ?
2. What should happen after pressing "ADD" ? - precise description
3. What should happen after pressing "EDIT" ? - precise description
4. What should happen after pressing "FIND" ? - precise description

Describe the criteria for proper operation.

[torachan]

Hi J.
Attached your app with buttons coded.
I have used tables and arrays to load/update records.
I am not sure what field you wish to use for primary search, therefore have defaulted to adding a listbox, use this as your search method.
You could resort to multiple comboboxes if you want to search on more than one key field.
At present I have defaulted to the order number to sort the table after addition/deletion.
Hope this gives some assistance.
torachan.

[JNEWMAN]

Hi torachan
I really appreciate you helping out with this and all the thing you have added work. Would it be possible to change the list box on the data input screen to just a drop down option to show a list of Order No's? This way it could be used as the find option to edit records and then select update.

Thank again for all your help

J

[JNEWMAN]

Hi, sorry for late reply and point taken on the limited information I hope below provides what I am thinking. Many thanks for you response

1. Should any default values be loaded into the text boxes or should they be empty ?
> Boxes should be allow any required data to be entered, no default values

2. What should happen after pressing "ADD" ? - precise description
> Add works at the moment which loads the input data into the next available row in the Data worksheet, no change required

3. What should happen after pressing "EDIT" ? - precise description
> Ideally it would ask for the Order No. and show all date related to the Order No. to enable editing

4. What should happen after pressing "FIND" ? - precise description
> Find would do similar to Edit where it would ask for the Order No. to be entered but just show the record detail no editing option

[torachan]

Hi J.
I have removed the ListBox and replace with a ComboBox (with dropdown list (this is now your search tool))
1) You can leave empty (except first two as these are checked to ensure you do not fill the table with blank rows)
2) At present I have left the 'sort procedure' in as it would make looking for order numbers messy if they are randomly entered.
3) No 'EDIT' now the 'UPDATE' button - you use the ComboBox first to search - then change(edit) details followed by pressing 'UPDATE'.
4) No 'FIND' the ComboBox is your find tool.

[JNEWMAN]

Torachan I can't thank you enough, it now provides everything I needed in this tool. Your time and knowledge are so appreciated, I got to a stage with it and couldn't get past it without causing more issues.

Best wishes
J

[torachan]

Thanks for the feed-back, if that solves your requirement please mark the thread as solved.
torachan.