Hi all,<BR><BR>I have a form for my Access database (there is no use of internet) and I have a command button that allows me to go to another form (open form action) I have set it to that it opens the form and finds specific data to display so that if my first table record ID = 1 then any of the 2nd table IDs that equal 1 are allowed to be displayed.<BR><BR>My problem is that when I open up the form and go to add a new record (using a command button with add a new record my record ID defaults back to zero, where as I want it to equal the same record ID as what I had.<BR><BR>How do I set up a command button so that when I go to adda new record my ID is set to a certain number based on what I had selected?