I have a form which I am using to enter employee data. I have a drop down box at "company" which when selected will poopulate text boxes on the form associated with the selection which are then linked back to the employees table. The only thing written to the employee table is the ID associated with the company.
However, if I want to make a different selection...say I selected the wrong company, then I get stopped and the DB states "To make changes to this field, first save the record". This is fine...I can add a Save Record command after the update event but then, as I have required fields on the form which the user hasn't yet entered into, I get the error that those fields need to be completed.
So, how can I update these text fields from the Combo box selection without saving to the employee records table until the very end? What could be firing off the command to write the record when all I'm doing is selecting from the combo box?
I would apprecaite any advise.