Well, while this can be done, you are probably asking for trouble......I would venture to say that setting something like this up as "idiot-proof" would be far from idiot proof.
Reasoning:
About the only way to work something out like this is to use the OnCurrent Event of the form. If you simply create some variables and repopulate the new record with this, you are bound to copy data from one record to the next inadvertently, because every time you move from record to record it will copy the data....you could probably work in some code that checks the form's current record set, and if you are at the .eof marker, then copy the data in.....but I still wouldn't recommend it. You could also probably fill the vairable, and check if the field is null when moving through recrods....but again, you stand to have problems....
My immediate suggestion is to create comboboxes for you selection instead of text boxes....reasoning for this is that a combobx can beset to autofill, so the user will only have to enter the first couple of letters and it will fill in the rest...if you set the combobox limittolist propery to no, they can use items not found in the list, but will have to type them out completely.... Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. (Albert Einstein)
Robert L. Johnson III, MCP, Network+, A+
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com
