I want to have a way to add a record to my Access database. I'll be adding a selection and a date. I though it would be easiest to have a basic form popup and then you just select the item and enter a date and click ok. The issue arises in that I want to add a record of which account you are doing this for. I.e. there are 3 pieces of data to enter in the record: accountId itemNo dateEntered How can I pass the accountId that is active in one form to the new form when it's opened? Or is there a better way to do it. Once the accountId is in the new form I can just do a DoCmd.Runsql to insert all the info on screen.