Novice
Windows 10 
Office 365
How can I have a form field input automatically update the underlying lookup table list. For instance, if the form field is "Color" and through the lookup wizard it pulls its possible values from a ColorTable that has values "Blue" and "Green" only but I want to add "Red", how can I add "Red" into the form such that it will update the table with the extra value and next time drop down 3 possible choices instead of 2? Thanks!
Virtually Inert Person
Windows 10 Access 2016
Color is a combobox? Then you could use the Not In List Event. One of many sources for this:
https://docs.microsoft.com/en-us/off...obox.notinlist
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Autoupdate Record
Posting Permissions
Reply With Quote