Using Access 2007, I have a simple application consisting of two forms with a nbrID numeric (non-auto) primary key. These forms basically capture donation information and update a donor database. My question is: How can I, using a simple command button to save updated information on FormA, then go to FormB with the same current donor record to continue data entry on the current record?
As it is now, FormB defaults to the first database record whereby we have to manually go down to the current record to continue our data entry. I'm a little more familiar with macro solutions v.s. VBA solutions. I think I just need to enhance my macro that advances FormA to FormB but I don't know how to maintain the current record. Thanks!
As it is now, FormB defaults to the first database record whereby we have to manually go down to the current record to continue our data entry. I'm a little more familiar with macro solutions v.s. VBA solutions. I think I just need to enhance my macro that advances FormA to FormB but I don't know how to maintain the current record. Thanks!
Comment