This may sound a liitle more simple than it is. I have a form that users fill out to start projects, the primary key is an autonumber field (CHARTER NUMBER). At the bottom of the form are command buttons to different blank forms. I want a user to be able to hit the button and have the CHARTER NUMBER populate the CHARTER NUMBER field on form2. This is where I get sidetracked, the user may have to fill out more than one (sometimes up to ten) of these form2 documents. I want as many as they need to have the CHARTER NUMBER filled in by the press of the button on form1. I've got a field called 5S# which is an autonumber and arranged as the primarykey on form2. The code I'm using doesn't work.
williekay
williekay