In the click event for the add button put something like:
CurrentDatabase.execute "insert into myTable values('"+Me.textBox1+"')"
This is bare minimum, you should probably add logic to test for empty strings etc if appropriate. Best Regards,
Mike