Fantastic!! That's what I needed, thanks!...

Hi,
I think I have a simple question that I just can't figure out. I want to have a command button on a form (via a macro) run a query to append the data on that form to another table.I want it to append the current record on the open form. I am not familiar with VBE so I want to use a macro.

How does the query pull the current record? I have an ID field and have tried setting the focus on that field but it still pulls all the...

Hi,
can you explain exactly how you do this? Where do you enter the Forms!FormName! ControlName?...