G'day again,
This question follows on from my previous thread about finding a record to edit.
I fell into what is probably a typical newbie trap. I had each of my forms open at a new record and then I was going to have the user search for the record that needed updating. What I found was that each form created a new record instead of editing the existing record.
I have removed the code that makes the forms default to a new record for two of the forms.
One form creates the record and enters initial program data and then the other two forms provide the engineers and configuration personnel the fields they need to update throughout the project.
Now to my questions.
Is the On Load event or the On Open event the correct place to have code that asks for the record number that requires editing?
Is a button or combo box in the form header the proper place for this control?
Eventually, I hope to have a dashboard that the user sees and where all data entry, reports, and updates are initiated.
Should I leave the form filtering until the dashboard is created and place the record search there?
This question follows on from my previous thread about finding a record to edit.
I fell into what is probably a typical newbie trap. I had each of my forms open at a new record and then I was going to have the user search for the record that needed updating. What I found was that each form created a new record instead of editing the existing record.
I have removed the code that makes the forms default to a new record for two of the forms.
One form creates the record and enters initial program data and then the other two forms provide the engineers and configuration personnel the fields they need to update throughout the project.
Now to my questions.
Is the On Load event or the On Open event the correct place to have code that asks for the record number that requires editing?
Is a button or combo box in the form header the proper place for this control?
Eventually, I hope to have a dashboard that the user sees and where all data entry, reports, and updates are initiated.
Should I leave the form filtering until the dashboard is created and place the record search there?
