How do I transfer the key field from one form to another in Access
Posted on 2011-03-10
I have two forms that share the same key field are are visible on both. One form has a button that opens the other form, but I have to search for the data in the unique key field via a combo box in form 2 to generate the record from the active form1. Is there a code I can use where I can click the button on form1 to open form2 and the unique key field will load into form2 from the active form1? It's similar to a record selector where you can click and other form of that same record will show.