Add multiple entries under same ID in userform

**cherias** · 09-27-2015, 02:00 PM

Dear Experts,

Thanks for all your suggestions and inputs you have provided me for different queries I have posted on this forum. Request your help again for an enhancement feature, to include in my existing user form.

I have attached screen shot of user form, which is to input data for service requests. As per the current user form, under a service request ID we can input only single SITE CODE and related details. However, I am looking to enhance the user form, so that under the same service request ID, we can add multiple SITE CODE (dynamic) and then accordingly, update related details specific to that SITE CODE.

In the database sheet, the different SITE CODE's and related details should fall under the same Service Request ID.

However, I am wondering that with such feature, how the SEARCH functionality work in user form. Ideally, I searched with Service Request ID, it should display in list box, all SITE CODES added under it and if searched with SITE CODE, it should display details, specific to that SIDE CODE.

To help better get a somewhat better picture, I have added a screen shot of the user form, I am currently using.

Thanks a lot.

**Tinbendr** · 09-27-2015, 08:59 PM

I won't think you'd need a search box just for SR number and site code. If I understand your request, you should use a Combobx for the SR numbers, then load all the site code into a second combobox. Upon selecting the second combobox, the rest of the userform is filled out. To me, if you already display the record in textfields, then a listbox, displaying the SAME information is redundant.

If you want to add an additional site under a SR number, then use the Add New Entry button to accomplish that.

If, however, you're searching for text in all of the records, then your approach is correct.

**cherias** · 09-29-2015, 03:52 AM

Hello Tinbendr,

Thanks a lot for your input.

If possible, request you to help me with the appropriate vba code for the same.

Thanks a lot

**Tinbendr** · 09-30-2015, 02:10 PM

I'll try to get an example together, but it might be this weekend before I can get to it. (Unless you can provide sample sheet, data & userform.)

In the meantime, search for cascading or dependant comboboxes. That is the technique I'm refering to.