My name is Assaf Lasry and I'm a junior programmer in VB6. I'm currently working on a software and I have a small problem. I have a database (MS Access) and I have a table called post that has 3 fields (InitialDate, Terms, Late). In my VB form I have a combobox, and a text box that has the current date. In the combobox, I have 3 options (30, 60, 90). Whenever i select an option(i.e. 30) and save the information, in the database, the terms field gets the value 30 and the InitialDate field gets todays date. Terms means the number of days. Now since my terms are 30, I want that when 30 days have passed, I'm suppose to get a 1 in the Late field. How can I do that and what my code suppose to look like. Please I need help. I would really appreciate your answer.
Thank you in advance,