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

Dippies

New member
Local time
Today, 16:03
Joined
May 21, 2020
Messages
14
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.
 
what type of lookup? a valuelist or table/query?

And where and how did you add the values?
 
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.
 

Attachments

  • Access1x.jpg
    Access1x.jpg
    156.1 KB · Views: 124
  • access2.jpg
    access2.jpg
    3 MB · Views: 134
  • access3.jpg
    access3.jpg
    3.8 MB · Views: 129
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
 
What you are describing is a control with a list for its row source.


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.
 
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.
 

Users who are viewing this thread

Back
Top Bottom