I have a form in which users enter date in a table, and then upon pressing a command button run an append query, to append data into an existing table. (This append query needs to append data from this one record only) How can I have the data entered into one of the control boxes passed to the append query?

Set the criteria on your key field to =Forms!MyForm!MyKeyField