I have been reading alot on this subject and there appears to be many methods. I need a method that applies to my situation, but not sure how to do it. I have two tables and two forms. I want to fill in the first form then push a button to open the second form and have the current primary key value from form 1 inserted into a field in form 2. Do I use a filter, macro, module, stored procedure? Could someone give me some direction please?