Combo Box / Value List variables doesn't copy over to a next PC when installing the program (1 Viewer)

[Dippies]

Good day all,

I have done a lookup on various fields ages ago.
I added new values to it on my laptop (Right click, add items to value list)
I successfully added new values.
When I copied the program onto the client's laptop, these values didn't show????
Why?
Where are these values stored? (Part and parcel of the forms module?)

Your advise is appreciated.

 

[CJ_London]

what type of lookup? a valuelist or table/query?

And where and how did you add the values?

 

[Dippies]

what type of lookup? a valuelist or table/query?

And where and how did you add the values?

Combo Wizard
Right click to add a value
See attachment
No tables involved.

 

[CJ_London]

I am unable to replicate the issue - perhaps you copied the wrong program? Or didn't save the form after making the changes.

Value lists are stored as a property of the control - view control properties and you will see them in under the data tab.

In my tests,

• I created a control using the wizard as you did.
• saved the form.
• Reopened - made changes to the list using your method
• saved the form
• reopened - still there
• copied the app to another computer
• opened the form and the list includes the changes

 

[The_Doc_Man]

What you are describing is a control with a list for its row source.

ComboBox.RowSourceType property (Access)

Office VBA reference topic

learn.microsoft.com

You can have a combo box, for example, where the row source type says "VALUE LIST" - in which case the .RowSource is a string that enumerates the values that will appear in the combo box. Verify that the object in question says "VALUE LIST" before you try to do anything else with it.

 

[Dippies]

I am unable to replicate the issue - perhaps you copied the wrong program? Or didn't save the form after making the changes.

Value lists are stored as a property of the control - view control properties and you will see them in under the data tab.

In my tests,

• I created a control using the wizard as you did.
• saved the form.
• Reopened - made changes to the list using your method
• saved the form
• reopened - still there
• copied the app to another computer
• opened the form and the list includes the changes

Thank you much appreciated.