removeitem and listindex

[nparsons75]

I have this code but cannot get it to work?

Me.axlenumbox.RemoveItem axlenumbox.ListIndex

Can anyone assist with the placement.

My code is:

Please Login or Register  to view this content.

[Norie]

How doesn't it work?

[nparsons75]

Well on the userform I select the combobox. In there is data previously entered into a spreadsheet. Once i select the data (one of the data) in this combo box and press submit i do not want that item to appear again in this combobox. As it it, when i select the combo box again the data reappears.

[Norie]

Are you closing the form, opening it and that's when you find the value still there?

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

[nparsons75]

I have attached all files. In backpress stage 2 userform the combobox is called axlenumbox.

It may need paths changing to work for you in the userforms etc. The database viewer is just a viewer to duplicate the database.

each stage has an axle number that passes through it if it passed at the previous stage. Once selected and submitted at each stage i need it to show in the next stage but be removed from the stage it has just been submitted from.

I also need the data to remain in the database.

[Norie]

Do you need multiple userforms?

You could do the whole thing with one form with a multipage for each existing form.

[nparsons75]

I have had that suggested but i think i need multiple userforms. The reason is that each userform is located on a different PC within a factory. Each one adds there own data and submits to the database. Certainly open to better suggestions, Im new to VBA but trying. Love it, but difficult.

[Norie]

So the forms aren't linked?

[nparsons75]

no. The only link is the database (but they are still not linked). Each form submits data to the database. Each form also imports their data from the database. (axle number etc) The forms, open the database, submit the data and then close the database. I need it like this because if the database remains open others cannot submit. The risk is that 2 people will submit at the same time which will clash i guess but it is unlikely to happen. the databse viewer is required because as a manager, he needs to view that all the time without effecting the running of the system.

[Norie]

What happens if 2 people are using 2 different forms at the same time and try and submit data to the database at the same time?

[nparsons75]

then it will say the database is already open. (yes a problem). Fortunately the chances are slim but it can happen. It only opens for a split second.