Here is my situation. I am creating a form in a new database. The database is for debits. One debit check may have 1 to 90 parts associated with it. We are going to start logging these into a database. The first 5 fields (MRA#, CK#, Customer#, Invoice#, and Debit Amount) may have to be re-entered into the next records depending on how many parts are associated with that debit. How can I get those first 5 fields to repeat into the next record? For example, I enter the first 5, then enter the part number, item number, quantity, cost, DMR# and date. For the next record or so, the first 5 may remain the same, but the next 6 will be different. How do I get it to copy over?
Hope this makes sense and someone can help! Be gentle, macros and expressions are very complicated to me!
Hope this makes sense and someone can help! Be gentle, macros and expressions are very complicated to me!