-
I am developing a contact database program. I have form1 and form2. You input contact info on form1 and go to form2 to expand to other info (both forms use the same database but different data controls). When I go back to form1 and change to the next record on the data control, then go to form2 the same info from the previous record is still there. How can I get form2 to clear when I go to the next database record? Please help.
-
The best thing to do here might be to unload form2 when you exit it and then when you move to the next record on form1 you can refresh form2 and show it.
Clearing the record is easy on Form2, it is just a matter of setting all the text boxes to empty.
text1 = ""
text2 = ""
Ideally you should have the text boxes set up in an array so then you can just loop through an initialise them.
Hope this helps
