MS Access with VBA: How to make a Field on a Form that adds a new columns to table by lookup?
I need to create a Field that will function as a Lookup Field but that will look up Column Name (instead of cell content, as in the traditional Lookup Field) and add a new Column with the name specified if none exists. How can I do this, if not by inbuilt Fields by using VBA scripts?