I have a form which with command button that runs an append query and adds a record from my main table to a different table depending on what record is selected on the form (I have [forms]![frmAWARDRECIP]![NAME] in the criteria of the append query). On this form I have a subform of the "recieving" table. For some reason the record doesn't show on the subform until I close the form and come back in, is there some code I can add to the command button to have it refresh the subform? Please use exact VB. Thanks for your help.