I have a button on a form to add a new record. Is there a way to carry over one of the controls "a lookup combobox" value to the new record using macro actions? The "lookup combobox" gets its value from the key field of another table if that makes a difference.
I've found answers to do this with VB code, but would like to keep it simple.
Thank You.