Alright,
Problem #1 -
Im attempting to append two values into a table when a button is pressed. There are two cases for this, for my first case it works fine. The second case involves choosing a pre-existing record to append into a reference table. Here is the code:
DoCmd.RunSQL "INSERT...