Update ComboBox rowsource with Value List

[Shinta]

Greetings:

I've searching in the web for a while and perhaps I've been foolish, but I cannot find a concrete answer for my issue.
At Microsoft online Access API site, says that if I've a ComboBox with a rowsource as Value List, I can update it's values via VBA with a list of items (a String), in which its elements are separated by a semicolon (";")
https://docs.microsoft.com/en-us/office/vba/api/access.combobox.rowsource

I even found an example on the web that confirms this. Still, I just cannot make it to work.
https://stackoverflow.com/questions...ow-source-of-a-bounded-combo-box-in-ms-access

I've created an Access DB which shows this scenario (attached to this message), in which I've two ComboBoxes; one which triggers an event and tries to update the Value List of a second ComboBox. I guess that I'm missing a basic concept for this to not work...

Thanks a lot in advanced for your interest and help.

 

[Gasman]

It works if the combo is not bound?

Plus who puts the first combo dependent on the second combo?, normally the other way around?

 

[Shinta]

It works if the combo is not bound?

Greetings... yes, it works if the affected ComboBox is unbound; any way for it to work if the ComboBox is bounded to a Table (besides using a query, that is)? or is this part of the Access definitions and there is no way around?

Thanks for the quick response

 

[Gasman]

No idea. I have rarely used value lists.
Also I could not find where the A,B,C came from when I cleared them from the properties.?

I seem to recall there is some feature/bug where they are remembered.? :-(

Best wait for an expert.

 

[theDBguy]

I seem to recall there is some feature/bug where they are remembered.? :-(

Sorry, I can't download the attached file right now, but are you two maybe talking about this?

Combobox Gremlins

This time, I thought it would be nice to have a little fun for a change. So, in this blog, I will need your participation. I will post a que...

thedbguy.blogspot.com

Sent from phone...

 

[Gasman]

Sorry, I can't download the attached file right now, but are you two maybe talking about this?

Combobox Gremlins

This time, I thought it would be nice to have a little fun for a change. So, in this blog, I will need your participation. I will post a que...

thedbguy.blogspot.com

Sent from phone...

That could well be the article I am thinking of @theDBguy

 

[June7]

@theDBguy, file download link in that web page does not work for me. Here is Colin's blog on same topic http://www.mendipdatasystems.co.uk/combobox-zombies/4594455053

If a combobox list is expected to change periodically, I would use a table source instead of value list.

 

[Shinta]

Hello again...

So, I've downloaded the "Zombies ComboBox"... and well, I can't get pretty well the use of it. I mean... is this related to the Value List issue I posted in the beginning of this thread? or is it more related to Gasman's concern of a "feature/bug" natural to Access's ComboBoxes?

Sorry if I just can't connect this last posts with the subject here...

 

[Gasman]

I believe it is re my comment. However it will perhaps interfere in what you are attempting?
I know you were just trying out the logic, but I would also go for a table for the sources.

 

[theDBguy]

@theDBguy, file download link in that web page does not work for me. Here is Colin's blog on same topic http://www.mendipdatasystems.co.uk/combobox-zombies/4594455053

If a combobox list is expected to change periodically, I would use a table source instead of value list.

Link fixed! Thanks!

 

[June7]

Database was just a demonstration of issue, not intended for practical application.

Again, advise to use a table as data source

Also advise not to build lookup fields in table.

 

[theDBguy]

Hello again...

So, I've downloaded the "Zombies ComboBox"... and well, I can't get pretty well the use of it. I mean... is this related to the Value List issue I posted in the beginning of this thread? or is it more related to Gasman's concern of a "feature/bug" natural to Access's ComboBoxes?

Sorry if I just can't connect this last posts with the subject here...

Hi. I finally had a chance to download your file. Please see the attached modified version of your db. The Gremlins/Zombies puzzle was applicable to your situation. Cheers!

 

[MajP]

ComboBox.InheritValueList property (Access)

• gets or sets whether a combo box's value list is inherited from its field. Read/write Boolean.

Syntax
expression.InheritValueList

expression A variable that represents a ComboBox object.

Remarks
The InheritValueList property is effective only when the combo box is bound to a Lookup field and the RowSourceType property is set to Value List.

Could there be a dumber property?