View Single Post
 
Old 09-19-2020, 08:46 PM
Guessed's Avatar
Guessed Guessed is online now Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,975
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

I'm not a fan of doing work to re-create what I think you have in order to show you something that may or may not match. Please post a sample doc that shows your current code.

In the case of the code you have posted, the Change event on ComboBox1 shouldn't start by adding more values into the list of that same control and then changing the value of to the first item (which causes the same event to run). Doesn't this seem like an infinite loop to you?

It is generally poor practice to show a list and then when you user makes a selection from that list, suddenly add another couple of options to the list and change the selection to the original first item in the list.

You don't need multiple forms, a single form should do everything you need. Having multiple forms just forces you to reproduce and manage the same code in lots of different places.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote