I'm a new user to Access, & I have a question about some forms. Because I have so much different data to collect and enter into my database, I have different forms for different types of data instead of one big form that's unwieldy to use. I use the forms to enter data about my staff. So, for example, I have a basic information form where I enter things like addresses, phone numbers, etc. But then I have another form that I use to enter information about their positions once they're hired, for example.
This is the best system for us, but sometimes when we are entering data, we want to enter both types of data. I'm wondering if there is a way to "link" the two forms. I have a button control on the first form that opens the other form, but it would be awesome if clicking that button to go to the second form automatically brought me to the form with the same person's information automatically displayed instead of just the first record in the table.
Hopefully I've described what I'm looking for clearly, if anyone has any advice, it would be much appreciated. Thanks!