I want to do a lookup query and append the record to a history table before editing the data.

I created a macro to run the lookup query to append the record to history and it works fine. I did the same with the lookup query that allows the user to edit the record. I then converted them to vb and combined them. Code follows.

My thinking is to create a variable dim keyno longint
then pass keyno to the lookup queries....